So I have a material entry form with a lookup field to an unrelated form in it.

I have another form with a lookup field that shows records from the material entry form.

The issue is, I want to set the the lookup field in the second form to be based on the lookup field from the first material entry form, but it doesn't give me the option to choose that field. I'm assuming it's because it's a lookup field.

Is there a way to get around this?