If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to design to input info
Need a db where i can have many businesses and each business has many
employees. These business have their employees come to my seminar. I want to be able to create a form for the seminar call "SeeYouTomorrow" and then from that form choose the business that will attend the seminar called "SeeYouTomorrow" and from their choose a few employees from only that business that will attend the seminar called "SeeYouTomorrow". I get to the part where i can do a form for the seminar and then select the business (with a drop down menu) but when i try to choose the employees (in a drop down menu) i get all the names from all the businesses in my db to choose from. I only want to choose the employees names from the business that i selected from the drop down menu i create. How do i get ONLY the name of the employess from that business and NOT all employees from all the businesse? |
#2
|
|||
|
|||
how to design to input info
Take a look at "cascading comboboxes" in an on-line search tool or at
mvps.org/access. It think this is what you are describing. Regards Jeff Boyce Microsoft Office/Access MVP "Confused" wrote in message ... Need a db where i can have many businesses and each business has many employees. These business have their employees come to my seminar. I want to be able to create a form for the seminar call "SeeYouTomorrow" and then from that form choose the business that will attend the seminar called "SeeYouTomorrow" and from their choose a few employees from only that business that will attend the seminar called "SeeYouTomorrow". I get to the part where i can do a form for the seminar and then select the business (with a drop down menu) but when i try to choose the employees (in a drop down menu) i get all the names from all the businesses in my db to choose from. I only want to choose the employees names from the business that i selected from the drop down menu i create. How do i get ONLY the name of the employess from that business and NOT all employees from all the businesse? |
Thread Tools | |
Display Modes | |
|
|