Multiple Value Lists

[gersam]

I have three files, one main file and two sub files (company A, company . The two sub files contain company name and position lists for each. In the main file I want to do the following: if I choose company A from a pop-up menu then I want to see the position list of that company, otherwise if I choose company B, I want to see the postion list of that company. How can I do this...any ideas?

If this seems unclear, then go to "www.cars.com". What I want to do is similar. If you choose Chevrolet in the "Make" pop-up menu, then you get only the Chevrolet models in the "Model" Pop-up menu. If you choose "BMW", you only get BMW models in the "Model" pop-up list.

[bcooney]

what you want is called "conditional value lists." Search this forum or JMO's Database Pros site for examples.