What my problem is that there are several contact people for each company and what I would like to know is if there is any way I can select the company for a particular record and then be able to select one contact out of the several that belong to the company.
I have been to the Microsoft site and have looked at what they have which are 2 combo boxes based on 2 tables but when I try to make mine work I'm not having much success. I'm not sure whether I'm not working out the code correctly.
My Access skills are self-taught - I have no programming skills.
Any help would be greatly appreciated.
Thanking you in advance,