Hi, I am relatively new to ms access and am wanting to do the following on a data access page.
1) User would select a customer 2) Based on selection of customer the next drop down box would show available branch locations 3) Based on customer and location selected another drop down list would be narrowed to show all the staff that only work at that branch I have a table which has all customers and a table which has all staff and branches. In this second table customer field is "looked up" on the customer table. The question is can this be done and if so how? I would be grateful for any assistance on this one. Many thanks Drew
