[AccessD] referential integrity in a relationship

Arthur Fuller fuller.artful at gmail.com
Wed Mar 28 09:41:37 CDT 2012


Best approach, IMO, is to add a column to TableA, make it Autonumber and
Primary Key. Then add a Long Int column to TableB and manually populate it
with the desired values from TableA's PK. After that, you're rock-solid.

A.
Only two businesses identify their clientele as users: drug-dealing and
software-development.
-- Arthur Fuller


More information about the AccessD mailing list