[AccessD] referential integrity in a relationship

William Benson vbacreations at gmail.com
Wed Mar 28 12:40:18 CDT 2012


I will check this out next week guys.. vacation now!
On Mar 28, 2012 10:42 AM, "Arthur Fuller" <fuller.artful at gmail.com> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list