Building a lookup table linked to a form

[JohnnyAmateur]

Hey, any help on this subject would be much appreciated, as you can tell by my handle I am fairly new to Access:

I need to build a lookup table that accomplishes the following; there are 3 drop down boxes on the form that I have built, each containing 2 errors. There are 3 more drop downs, each corresponding to the error drop downs, that contain 8 recommendations to correct the error. What I need to accomplish is that when a user selects an error from the drop down on the form, the corresponding recommendation will automatically come up in the other corresponding drop down. I know that I need to create a lookup table to accomplish this, but how should I set it up and what do I need to put in to make it work?

 

[mikey69]

A possible way of doing this is to build alternative queries as the data sources for the various subordinate combo-boxes. You'd then have to set the second combo box's row source property based upon the criteria implied from the initial combo box. You'd have to do this using Visual Basic for the initial combo box's after update event.