Conditional Values based on unrelated fields
I have the following relationships
Manufacturer ----->Model
Manufacturer------>Assets
Model---------------->Assets
Location------------->Assets
Assets---------------->Ticket Assets
Ticket...
Forum Discussion
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.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
That does the trick! Thank you!
------------------------------
Nate Kurtz
------------------------------