W
whitjl143
Access 2002
I have a company table, a contact table and an orders table.
I use the orders table for my form.
On my form I have a combo box that looks up the company name from the
company table.
I have another combo box that looks up from the contacts table.
I need the contacts combo box to show only the contacts for the company
chosen in the company combo box. Then I need the discount for the contact
chosen to appear in another field on the form.
Any help out there is greatly appreciated!
I have a company table, a contact table and an orders table.
I use the orders table for my form.
On my form I have a combo box that looks up the company name from the
company table.
I have another combo box that looks up from the contacts table.
I need the contacts combo box to show only the contacts for the company
chosen in the company combo box. Then I need the discount for the contact
chosen to appear in another field on the form.
Any help out there is greatly appreciated!