I have a form called [Master Inventory] and among its fields there are a few in particular...

Device ID

Assigned To

I have another form called [Work Order] which has a subform called [Work Order Subform].

In the subform I have a lookup field called 

Device ID

In the subform when I click the Device ID drop down field I would like to only see Device IDs where the Assigned To equals a field in the [Work Order] parent form called "Installer".

Is this possible? If so how would I do this?