Hi,

I need help to filter a subform lookup field based on a field in the parent form. for example, I want to enter a job number in the parent form and have a lookup field in the subform only show phase codes for that job number.