If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationships
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. |
#2
|
|||
|
|||
Relationships
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. -- _________ Sean Bailey "4charity" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|