This almost does what i am looking for.
Imagine I have a lookup table for fruit:
And then i have a Customer Order table that looks like:
Looking at the above, we see that the customer with ID 1001 ordered 10 bananas.
I want to present a dropdown list with the information from the fruit lookup table.
The values you get to choose from are the text values (“Apple”, “Banana”, “Orange”), but the value I want to pass along as a variable is the associated ID (2 if I pick “Banana” from the dropdown, 1 if I pick “Apple” from the dropdown and so on).
The Value Selection Widget seems to only let me pass the actual description value, not the value from the associated ID column.