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

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

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


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
stateid of the current record in it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top