Conditional Values based on unrelated fields

I have the following relationships

Manufacturer ----->Model

Manufacturer------>Assets

Model---------------->Assets

Location------------->Assets

Assets---------------->Ticket Assets

Tickets--------------->Ticket Assets

What I would like to do is use several lookup fields to filter and select the Asset I want to make my Related Asset when creating a Ticket Asset. Right now I can make the Asset conditional on the Model, and the Model conditional on the Manufacturer, however as the Location is not directly related to Manufacturer and Model I can't also filter by Location.  Any suggestions on how to do this?  

To sum up what i actually need to happen out of this:

I need to have a way of finding and selecting an asset that has a specific location, manufacturer, and model (this would bring back a group of them).  I would then pick one at random to associate to my ticket asset. Then when I close my ticket I have an automation run that moves the location of the asset out of that list so our inventory is accurate.  This seems like a really simple thing that i can't seem to get past.  

Thanks in advance for any help you can provide!