Not sure I follow how to add the id's behind the description. I have tried using the item pairs but i thought was for list like a,1 b,2 etc not sure how to put the table names in the item pairs or is that even possible.
Thanks.
No, if you know what
RIVATE-DATA is, it's basically the same as the List-item-pairs only for combo boxes and selection lists, etc. It displays the first value that you add and hids the second value behind. Say you want to show an employees name but you want their employee ID stored behind as well.
Using list item pairs:
ComboBox1:Add-Last(Employee.EmployeeName , Employee.EmployeeID).
Now when you use ComboBox:Screen-Value to get the value out you will retrieve the employees ID, not their name that the user is seeing.
Using List-Items:
ComboBox2:Add-Last(Employee.EmployeeName).
***Notice there is no comma because its only list-items, the comma seperates the two values so progress know which is the displayed, and which is the hidden on you can reference with SCREEN-VALUE.***
So when you go to Call, or assign the Values of those combo boxes you will get:
string1 = ComboBox1:ScreenValue.
string2 = ComboBox2:ScreenValue.
string1 will display the employees ID, altho the user couldn't see it.
string2 will display the employees Name because its list items, not pairs, so it will show you the data the user sees.
The reason for List-Item-Pairs is the keep users from seeing private data that you dont want them to see but still gives your program access to it to use on querys, lookups, etc.
Also MAKE SURE, your comma is
not in quotes or it will interpret it as a string and display it all.
Good luck.