Lookup based on a lookup

C

ChevZ

I need multiple lookup tables. The first lookup is "Line" It could be "1",
"2", or "3". The next lookup is "Equipment" this could be "Loader",
"Buffer", "Pick and Place", etc.... If Line 1 is selected in the first
lookup, the equipment on Line 1 will be in this lookup. If Line 2, then Line
2 equipment will come up, etc... I probably will also need a third for
"Downtime Reason" as well but if I can get some help with the 1st two I
should be able to figure it out.
 
K

KARL DEWEY

Your tables needs to be setup like this --
Main
ID Type
1 Equipment
2 Service
3 Xccc

Sub
ID Sub Type
1 1 Bulldozer
1 2 Skiploader
2 1 Hauling
2 2 Trenching
2 3 Grading

Downtime
ID Sub Down Reason
1 1 1 Scheduled Maintenance
1 1 2 Repair
1 1 3 Transport unavailable
2 2 1 Driver sick
2 2 2 Weather

Create ComboBox1 with record source from main.
Create ComboBox2 with record source from query with ComboBox1 as criteria
for ID.

And so on.
 
C

ChevZ

KARL DEWEY said:
Your tables needs to be setup like this --
Main
ID Type
1 Equipment
2 Service
3 Xccc

Sub
ID Sub Type
1 1 Bulldozer
1 2 Skiploader
2 1 Hauling
2 2 Trenching
2 3 Grading

Downtime
ID Sub Down Reason
1 1 1 Scheduled Maintenance
1 1 2 Repair
1 1 3 Transport unavailable
2 2 1 Driver sick
2 2 2 Weather

Create ComboBox1 with record source from main.
Create ComboBox2 with record source from query with ComboBox1 as criteria
for ID.

And so on.

How do I force the query to run when I leave ComboBox1
 
K

KARL DEWEY

Build an event or macro to run when ComboBox1 is updated. This is done in
query design view - right click the ComboBox1 and select properities. Have
it update query for ComboBox2 and ComboBox3.

Have ComboBox2 update query for ComboBox3.
 
C

ChevZ

KARL DEWEY said:
Build an event or macro to run when ComboBox1 is updated. This is done in
query design view - right click the ComboBox1 and select properities. Have
it update query for ComboBox2 and ComboBox3.

Have ComboBox2 update query for ComboBox3.


Thank you. Much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top