Conditional Values based on unrelated fields

So, you'll need to set relationships for Location, Manufacturer, and Model to the Ticket Assets first. Then, you'll need to create a formula field on both the Ticket Asset and the Assets that concatenates the Reference Fields for Manufacturer, Model, and Location. Once you have this, you can set the Conditional Drop-down to use the Formulas on both tables as the matching parameter.