Lookup field on data*** view

Hello all,

I have a form which contains a subform. The subform is a data***.

With the data*** 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 data*** 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

.

Quantcast