Dynamic pop up menus
I am working on a project that has three databases: clients, store location and salesperson.
Here is what I am trying to achieve: in the clients layout, I would like to have a pop-up menu with the location of all the store from the store location database. I was able to achieve that by using a pop-up menu that has a value list from the store location database. Now, once I have selected the location, I need a second pop-up menu, also in the clients DB, to adjust automatically with the names of all the salespersons at that location. So far, I was not successfull...
Any input would be appreciated