"Lost" Contact Data

message from =?Utf-8?B?Sm9obkx1dGU=?= on 10 May 2004
In the course of adjusting table relationships my Contacts became "detached" from their relative Suppliers. I've corrected the relationship problem. How can I reattach my Contacts to their Suppliers?

Thanks!
 
Armen Stein replied to =?Utf-8?B?Sm9obkx1dGU=?= on 10 May 2004
The way a relational database "attaches" related records together is
through linked key fields. In your Contact table, you should now have a
"SupplierID" or similar field. This field needs to be populated with
the appropriate SupplierID for each Contact. If this linking
information was lost during your relationship changes, you'll need to
type it in again manually.
 

Archived message: "Lost" Contact Data (Microsoft Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.