Hi all
First post here.

I have a question which is probably very simple to answer
I have a database with the following tables:

tblPart
tblPartGroup
tblPartType

tblPart which has the fields:
PartID - unique
PartGroup - lookup to tblPartGroup
PartType - lookupto tblPartType

In tblPartType i have fields
PartGroup
PartType

A part can only be one group but a group can have many types.

Is there a way I can restrict the entries in tblPart in the field PartType so that only types that are a child of the group selected in the field PartGroup are shown in the lookup list?

Hope you can help.

TIA

The answer is yes, but with a form. Let's start by reading this linked (http://www.mvps.org/access/lookupfields.htm) article.