I am having a problem with how to get a lookup to work how i want.
What i want is the user to be able to use the lookup on a form to
select the supplier for that product however there is different
classes of supplier and i only want them to see the relevent class on
that form?

All suppliers are held in one table with their own ID Name and Class

The job table is the other table where one record will contain
multiple items all of which could be a different supplier and will
store the supplier ID.

Its simple using the lookup wizard to creata a lookup to do this but
how do i limit it on the supplier class?

Any help greatfully recieved
Glyn

Please post only once. See answer to your second msg.
-Ed

"Splashout" <splashout1 (AT) yahoo (DOT) com> wrote