Linking tables

ICTkirsten

Registered User.
Local time
Today, 01:43
Joined
Jan 3, 2015
Messages
137
Hello,

I am creating a booking system and i have an issue with linking tables.
I Have a table that contains customer details and another table contain customer prescriptions.

I want to be able to have the names from customer details in this table because at the moment i have to type it in myself...
I want them to link but im unsure as to how I Should go about this.

I hope this makes sense.
Thank you
 
If you want to have the customer name in both tables, then your setup is wrong!
But why do you want to have two tables, the way I read it you only need one table?
Here is a link to "How to define relationships between tables in an Access database"
https://support.microsoft.com/kb/304466?wa=wsignin1.0
 

Users who are viewing this thread

Back
Top Bottom