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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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


Robert Gilland said:
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
Click to expand...
stateid of the current record in it.
 
Back
Top