That worked for me, thank you very much. This site is so brilliant and lots of people have had the same issues as me so searching threads is perfect.
Thanks
Nellyville
hi Bob, thanks for your help. Although I didn't understand what a foreign key was, I went onto Microsoft site and understood that - your response worked :)
Thanks a million
Rgds
Nellyville
Hi
I am trying to use 3 different tables to create an enquiry form/table
I have the following tables
customer data
product data
and I am using a form to create enquiries I receive into an enquiry table
I have managed to link the customer data so that when I select a customer from a combo...
Hi everyone
Firstly, thank you to anyone who helps me from now on.
I am not a new user to Access but have not used it for many many years - hence I am currently doing this :banghead: whilst building a new Enquiry/Quote database!!!!
I live in the UK and consider myself a reasonably switched...