Lookup field value dependant on another table value

[mromyn]

Hi -
I need to have two lookup/dropdown lists in a table where the second
dropdown is dependant on the what was entered int he first drop down.

So for example, if I have a list of charge codes (1111,2222,3333) and the
user selects 2222; they have a choice of (Labor, Supplies,Overhead). If they
select 3333; they will have a choice of (Entertainment, Meals, Transport).

I have tried Bound columns and setting a query inthe row source. But the
Query doesn't reference just the active record, it will select all values
that have been entered. DOes anyone know how I can set this up?

Thanks!
Mel

 

[Tom Wickerath]

Hi Mel,

I need to have two lookup/dropdown lists in a table....

No, lookup fields defined at the table or query level are evil. See the 2nd
Commandment of Access, here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm

Here is one method of accomplishing your goal, using a form. Users should
only see forms and reports; they should never have direct access to the
tables, queries or the Database Window (Nav Pain in A2007):

How to synchronize two combo boxes on a form in
Access 2002 or in Access 2003 <---valid for other versions as well
http://support.microsoft.com/?id=289670


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________