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?

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?