I am trying to create a form that will display address information in two different sub-forms from the same tables on the same screen at the same time. There are three tables (Customers, Addresses and Contracts). In the Customer Table the primary field is "CustomerId" which is text (field size 10) and has a one to many relationship with CustomerId fields in both the Addresses and Contracts tables. Contracts sometimes involve more than one customer (i.e. the contracting a/k/a the paying customer and the location customer) so a "LocClientId" field was added to all three tables in addition to the "CustomerId" field (text field size 10). But I can't get anything related to the LocClientId to work on my subforms. Your help would be much appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Normalization Design and Form Problems
- Thread starter DataDevil
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
