Hi guys, I hope you are well.
I am back, working on access, but I am having trouble to get a simple job done.
Can you help me out?
I want to use a form and sub-form to display companies and its contacts.
The form should display the company info
The sub-form the contacts for the company
I have the 3 tables
vendors - primary key vendorID
contacts - primary key contactID
vendorContacts - primary key = vendorId and contactID
I want to be able to add new contacts to the company right on the sub form.
I build a query on the owners table to use it on the sub form.
I build a query on the vendors and vendorContacts table to use it on the form.
I want to embed the sub form into the form and set the master and child links.
Why does this not work?
Thank you.
Jorge Muralles
Posted by: muralles_r12@yahoo.com
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar