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?
December 30, 2008 9:46 PM
January 1, 2009 9:08 PM