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!
------------------------------
Nate Kurtz
------------------------------