By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,792 Members | 1,667 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,792 IT Pros & Developers. It's quick & easy.

Tables and Drop Down Boxes

P: 58
This is the scenario. I have a table “Main” with 2 fields: Location and Salesperson (actually it has several fields but I want to concentrate on these two fields. Also, I have a table called “Location” with three Records or stores (FW, WC, and W). These two tables have a 'one to many' relationship. On the other hand I have three other tables (FW-Salespersons, WC-Salespersons, and W-Salespersons). Each table has a list of salespersons of their corresponding store.
The idea is the following: if the Location field from “Main” table is chosen one of the stores, for instance, FW. I want the Salesperson field Drop Down Box from “Main” table to be change automatically to FW-Salespersons list, and the same thing for WC, and W stores. How would it be the best way to connect these tables in order to accomplish this task? If you have a suggestion how to do it, it would be greatly appreciated.
Thank you in advance.

Sep 18 '08 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 2,545
Hi plaguna. The use of tailored combo lists cascaded from one combo to another is covered in our HowTo article on Cascading Combo/List Boxes which should give you a start on how to do this.

Sep 18 '08 #2

P: 58
I’ll definitely look at your Howto article.
Thank you

Sep 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.