one-tone relationship 1

[asafblasberg]

Hello, I have a one-to-one relationship in in access project adp. problem is, how do you make sure that the foreign and primary keys are ALWAYS the same that they MATCH... is there some kind of rule you can do?

Asaf

 

[BobStubbs]

I would do two things:

-- Enforce referential integrity in the relationship, so that the key in one table cannot be amended, or a record deleted, without a corresponding change to the other table.

-- Make sure users do all record creation and updating via a form. Use VBA code to ensure (for example) that when a record is created in table A, a record with the identical key is created in table B



Bob Stubbs

 

[LittleSmudge]

And of cause you really need toanswer the question WHY do you have the table split in the first place ?

If you are ensuring that the referential integrity is there then whynot have it all in one table ?





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.