Hello all,

I have a form which contains a subform.  The subform is a datasheet.

With the datasheet I have the following fields

1) ID
2) Type
3) Workshop

The wokshop information is held in another tabe for lookup.

The user will choose a type "type 1" or "type 2",  I would then like
the lookup to show only workshops that are the relevent type.

Due to it being a datasheet view I am having problems with this, Is it
possible to do this a the table level, or am I thinking about this all
the wrong way.

Thanks in advance

Matr