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.