"Lost" Contact Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

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.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com
 
Back
Top