Creating a lookup drop down menu for multiple data tables

I have a company that services cars at different sites. I have 4 tables
(company sites, customers, cars, services) with information in each in those
tables. I want to create a form where the user chooses a "Company Site" from
a drop down box, then selects a specific "Customer" from another drop down
box that only contains the customers that are associated with that company
site. Then is is possible when the user selects a certain customer that in
some other fields on the form the information from the customer table on that
customer appears, ex) First name, Last name, Email, Phone#? Then from there
have another drop down box that allows the user to select "Cars" that that
customer has and that will open up information on that specific car in
dedicated fields on the form. And then from there be able to choose
"Services" in a drop down box and be able to choose the date of a prior
service on that vehicle and then in dedicated fields on the form information
on that specific service appears. Is this possible? Basically i want the user
to be able to look up specific customers at certain sites then their cars
specific information so we know how to service that car. Hopefully i can do
this. I am a new access user so not an expert yet.

You have undertaken quite a project. It can be done, but it is probably
beyond the scope of this newsgroup to walk you through the many steps. A
good place to begin is with basic information about how Access databases work.
Here are some links. IMHO Crystal's tutorial is as good a place as any to
start:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

To one of your specific questions, here is a link to information about
cascading combo boxes (where the selection in one box determines the row
source in another box):

http://www.fontstuff.com/access/acctut10.htm

A groups search for "cascading combo box" should yield a lot of additional
information.

It is best to use just alphanumeric characters and underscores in names,
including field and table names. Avoid spaces and special characters such as
# and ?.

SLR3016 wrote:
I have a company that services cars at different sites. I have 4 tables
(company sites, customers, cars, services) with information in each in those
tables. I want to create a form where the user chooses a "Company Site" from
a drop down box, then selects a specific "Customer" from another drop down
box that only contains the customers that are associated with that company
site. Then is is possible when the user selects a certain customer that in
some other fields on the form the information from the customer table on that
customer appears, ex) First name, Last name, Email, Phone#? Then from there
have another drop down box that allows the user to select "Cars" that that
customer has and that will open up information on that specific car in
dedicated fields on the form. And then from there be able to choose
"Services" in a drop down box and be able to choose the date of a prior
service on that vehicle and then in dedicated fields on the form information
on that specific service appears. Is this possible? Basically i want the user
to be able to look up specific customers at certain sites then their cars
specific information so we know how to service that car. Hopefully i can do
this. I am a new access user so not an expert yet.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200911/1