Restriction on lookup data!

Restriction on lookup data!

Hi

I have a Form(MachDetail) in which I have a lookup table
that looks up in a form(EmplDetails).

The form(EmplDetails) is a table of all employees in our
company that has the tables:

Name
Deptartment
plant
MailId
Local no.

In the Form(MachDetail) it must only be the employees from
R & D that is shown in the lookup table.

My apll. is open to you. (MD Request system ver. 2.0)

How can this be done?

BR Dennis