Registers

  • Thread starter Rolando São Marcos
  • Start date
R

Rolando São Marcos

I have the following table:

PartnerType (RefIDNPartner LONG, RefIDType LONG, BeginDate DATETIME, EndDate
DATETIME, PRIMARY KEY (RefIDNPartner, RefIDType),
FOREIGN KEY (RefIDNPartner) REFERENCES Partner(IDNPartner),
FOREIGN KEY (RefIDType) REFERENCES Type(IDType));

When i introduce a new register, i want the EndDate field of register1 has
the same date that the BeginDate filed of register2 that i am introducing.

I wope i make myself clear.

Thanks.
 
D

Douglas J Steele

You've posted to both Access and SQL Server newsgroups. Which DBMS are you
using?

You can't automate what you're trying to do in Access. You should be able to
create an Insert Trigger in SQL Server, though.

If you're using SQL Server, I'd suggest posting back, removing the Access
newsgroup from the list.

If you're using Access, post back just to this group, and we can offer some
workarounds.
 
Top