The ideal situation is using a new 'environment' dropdown that will pass it's token to the company dropdown to segregate the items listed in 'company' based on environment. I have two lookup files, each containing the relevant key/value pairings of that environment. Is it possible to use a token to change a search entirely based on what token is received?
In more detail:
Company dropdown search: | inputlookup xxxxxxx.csv | fields description, value | dedup description, value
The format of the lookup tables: 2 rows: value description value1 description1 value2 description2 etc...
Environment has two static values (field1, field1Value), (field2, field2Value). Can I pass in a different lookup table (or, just pass in a similar search with a different lookup) to the company dropdown, based on what environment token is given?
It's not lost on me that I may be going about this the wrong way. If I'm going totally the wrong direction, let me know.