Relationships

  • Thread starter Thread starter 4charity
  • Start date Start date
4

4charity

I am struggling with how to link some tables. I have created some very
integrated databases in Access in the past, but I do not use code....

I have a main client table that automatically generates a Client ID. Ihave
several other tables that I set up to keep track of other info for them
(addresses) (orders), etc. HOw do I identify the client in these other
tables? If I create a field called "Client ID" as a text field, and try to
link them in a query, I get a mismatch error. The info in these other tables
would be entered through a subform on a main form that already has the client
ID.
 
Since you said you "don't use code", I'm going to guess that the ClientID
field in your client table is AutoNumber, so the ClientID field in the related
tables need to be a Number (Long Integer) data type, not Text.

Then you would use ClientID as the Master/Child link between the main
form and subforms.
 
Back
Top