Hi ipazin,
This almost does what i am looking for.
Imagine I have a lookup table for fruit:
ID, FRUIT
1,Apple
2,Banana
3, Orange
And then i have a Customer Order table that looks like:
CUSTOMER_ID,FRUIT_ID,QUANTITY
1001,2,10
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.
Many thanks,
Mirri