Creating relationship table from Clients to Orders

RonW7341

Registered User.
Local time
Today, 15:31
Joined
Aug 16, 2011
Messages
18
I have a Client database table in Access. I now need to add a simple order table (related) to the client table. I have a client ID field set to autonumber in the client table. As I start to create the orders table I'm not sure how to link the two so that I'm not entering data twice and have assurance that they are tied together. Thank you, any help would be appreciated. :banghead: RonW7341
 
Your order table should have a foreign key field to the client table. In simple terms that means the order table should have a field called something like 'ClientID' which is a long integer and will hold the autonumber that is in the client table.
 
Ron,

In addition to plog's advice I really suggest you work through this tutorial to get a better understanding of tables and relationships.


Good luck
 
Last edited:
jdraw: Thanks for your response. The link you sent to follow will not open for some reason. Would you try to send it again, my email address if needed is roncathyw@att.net. Thanks again. ron
 
Sorry about that. Hopefully this works.

And Ron, see the group of videos at near the end of this old post -they should help clarify things. See this

Let me know if the links worked for you.
Good luck
 

Users who are viewing this thread

Back
Top Bottom