Hello!
I've got a requirement to build out an app using a few different fields from the same table, setting it up like a Lookup Select variable would function (i.e. referencing the column name for the lookup). I'm coming up empty on setting this up since that's not an option as a field type outside of catalog items.
For clarity:
- The same table is being referenced for all three fields
- Each field needs to reference a different column name for its data
- The columns are independently populated because of how the data is used. That means if Column 1 is populated, Columns 2 and 3 are not; If Column 2 is populated, Columns 1 and 3 are not; etc.
Any help is greatly appreciated. Thanks!
Erik
