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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!