I have a Products form with a lookup field on Factory form.

I have an Order form with a lookup field on Factory form

The Order form has a OrderItems subform with a lookup on Products form.

At the subform OrderItems I want the lookup on Products form to show only the records that match the Factory chosen at the Order mainform.

Is this possible?

Thanks :)