Menu Help and Such

[CrazyCanuck]

Here's what I'm trying to do:
Main table with columns - line, area, description

Line is a lookup table that looks up a separate table (which is just a list of lines).

I'd like to make another table for each line which contains all its areas.

So in the form, you choose a line from the lookup table (have this part figured out) and then the area lookup combo box is filled with the contents of the area table for that line. You then enter any description you want and save the whole thing to the main table.

Can anyone help me with this or send me to a similar example?

 

[neileg]

Sounds like you need cascading combo boxes. Do a search in here for postings on this subject.

 

[CrazyCanuck]

I have looked at that subject but it doesn't really give me what I need. My problem is grabbing the data to fill the second combo box from one of many tables depending on the first combo.

All the cascading examples have everything in one table with a number of extra columns for telling what data ties to what subject.

 

[Pat Hartman]

Sounds like a design issue to me. The rows that populate a combo should come from a single table. Otherwise, you cannot enforce RI on the relationship.

 

[neileg]

I agree with Pat.

If you can't hold everything in the same table, you should pull it together in a query. There has to be a way of linking the data in the combos together, otherwise there is no logic.

If there is truly no connection between the selections you make from the combo boxes, then these are just discrete. Presumably the user can select any combination they want.

Perhaps if you explain more fully, we may be able to help.