2. PHPRunner General questions
  3. Multiselect Combo: Get Id
This topic is locked

Multiselect Combo: Get Id

 		3/19/2013 11:35:31 AM
PHPRunner General questions
I
 imendes author

Hello,
I have a Multi select combo which is linked to the authors table (AUTH_ID, AUTH_NAME). In the BOOK table, the fiels Author contains the names of the authors separated by commas. It's all allright. But I need to know the AUTH_ID values, because I need those values to make some extra queries. How can I do that on Before Record Added/Updated ?
Thank you.
I
 		imendes author 3/26/2013

No one?
I just want to know how to get the link field value (in my case is Primary Key) on a multiselect combobox.
I need that values to make some queries.
Thank you.
Sergey Kornilov admin 3/26/2013

My guess is that in Before Record Added/Updated events you need to write a query first that will retrieve AUTH_ID values based on AUTH_NAME. Then you can apply the logic that retrieves data from other tables based on AUTH_ID.