Foreign Key other than ID of Parent
I would like to create a foreign key on a child table using a field other than Record ID, but retain the Record ID for the Parent table (to not disable existing relationships) Do you know if this is ...
Forum Discussion
This is an established app with 15+ related tables. I want to add a few new tables and thought the Foreign Table could perform the VLOOKUP automatically. I can then keep the Record ID as the key and prevent any orphan records if a SO# happened to be edited.