Minimize results in form.
I am trying to create an issue tracker for my company. The problem is that I have many contacts for each customer(Each contact will have their own record in the "customer" table). What I would like to be able to do is when I enter a new issue, I will select my customer from a drop down box that is referencing the "customer" table and then in the contact field drop down box I would like to see only the contacts related to that customer, so that I don't select a contact from the wrong customer or have to spend a lot of time scrolling. I don't know if I need a query to run from within the form to limit the contacts that I see?
Software/Hardware used:
Software/Hardware used:
ASKED:
December 30, 2008 9:46 PM
UPDATED:
January 1, 2009 9:08 PM
Answer Wiki:
Sounds like a table design issue. You should have a Customer table which holds the companies which are customers, then another table which holds the contacts for each company with a 1<N relationship between them.
To see all answers submitted to the Answer Wiki: View Answer History.
Are you saying that I will need a seperate table for each contact group or just one additional table for the contacts with the relationship established?
One table for Contacts and one table for Clients with a relationship between them.