Share
ReportHello everyone,
I need a little bit of help here please.
So, I've got a collection that is being created by the selected items of a combo box.
The items of a combo box are records of a database table's column.
I want to add another column on the collection which would include and retrieve the idents of the selected items from the database table.
Collection should look like this:
Column A - Selected items of a combobox (Item 1, Item 2, Item 3)
Column B - The idents of Item 1, Item 2 and Item 3 on the sql database table. (example 10, 20, 30)
Column A | Column B
Item 1 | 10
Item 2 | 20
Item 3 | 30
-----------------------------------------
What I currently get is:
Column A | Column B
Item 1 | 10
Item 2 | 10
Item 3 | 10
-----------------------------------------
It is not picking up the right idents for those items from the sql database table.
If I test it by hardcoding it, it works fine but I need smth dynamic cause its for a lot of records.
Im unsure on the condition I should use at the formula here
LookUp( sql_table_name, ?? , name_of_ident_column)
Any help would be very much appreciated 🙂
All responses (
Answers (
490
