How do you generate a lookup field for tables with more than one field in primary key

[Robert Gilland]

I have a data base which has look up tables that have more than one field in their primary key

ie
lookup table GROUP
stateid, groupid, groupdesc primary key is stateid, groupid

I want the lookup dataset to drop down only the groupdesc's with the stateid of the current record in it

Is this possible?

 

[Duane Hookom]

You can (and should) do this in a form. Roger Carlson has a small sample
database at www.rogersaccesslibrary.com that shows how to limit the values
displayed in a combo box.

--
Duane Hookom
MS Access MVP

I have a data base which has look up tables that have more than one field in their primary key.

ie.
lookup table GROUPS
stateid, groupid, groupdesc primary key is stateid, groupid.

I want the lookup dataset to drop down only the groupdesc's with the

stateid of the current record in it.