Having the hardest time creating the dropdowns I want.

[Greg]

I would like to create 3 dropdowns. I believe they are
dynamic dropdowns.
1. Company
2. Division
3. Jobsite.

First I want to select the company, then the division or
city its in, then I would like the 3rd dropdown to only
display the jobsites in that division for the selected
company.

I would also need an add form for the companys, jobsites,
and divisions as well since I don't want to duplicate the
companies, I rather select them from a dropdown if they
are already inputted in the DB, or type in a New company
and have that added to the drop down.

It doesn't sound like a difficult task but I just cannot
figure it out. I have no vb, java, or sql knowledge.

I do not know if I am setting up my table correctly
either. Can these all be in one table or individual tables?

I know I sound really confused, but I am.

Thanks,

 

[Lynn Trapp]

You should have a copy of the Northwind database on your computer. The
Orders form, I believe, has an example of doing what you need.

 

[Roxie Aho]

-----Original Message-----
I would like to create 3 dropdowns. I believe they are
dynamic dropdowns.
1. Company
2. Division
3. Jobsite.

First I want to select the company, then the division or
city its in, then I would like the 3rd dropdown to only
display the jobsites in that division for the selected
company.

I would also need an add form for the companys, jobsites,
and divisions as well since I don't want to duplicate the
companies, I rather select them from a dropdown if they
are already inputted in the DB, or type in a New company
and have that added to the drop down.

It doesn't sound like a difficult task but I just cannot
figure it out. I have no vb, java, or sql knowledge.

I do not know if I am setting up my table correctly
either. Can these all be in one table or individual

tables?

Based on your description you should have three tables.

tblCompany: CompanyID(Primary key), CompanyName, etc

tblDivision: DivisionID(Primary key), CompanyID(Foreign
key), DivisionName, etc.

tblJobsites: JobsiteID(Primary key), DivisionID(Foreign
key), other fields

One, but not the only, good source for help with linked
combo boxes is http://www.helenfeddema.com/access.htm

Roxie Aho
roxiea at usinternet.com