Dropdown from different table depending on another field

[atledreier]

Hello!

I have a table that needs to be filled in with data from a different
table via lookup (for ease).
My main table has a category field that should deternine what table to
lookup in my other fields.

En example:

I have the main table, with some regular fields, ID1 and ID2 fields,
and a Category field.
The category field should determine what table to use for lookup to
ID1, and ID2 should have lookup to specific tables if the category is
either 'I' or 'K'.

How can I do this?

Be gentle, I'm pretty new at this.

 

[Wayne-I-M]

Hi

I would use a form and some casscading combo boxes. You can simply select
the table source by refering back to the previous combo.

Search this site on Casscading Combos for lots of samples and explanations

Good luck

 

[atledreier]

Would this work on a datasheet as well? Most of my data is listed in
datasheets.
I'll look up the cascading combos anyway, thanks for the tip!

- Atle