one select update two fields with different values?
I have a product table contaning 3 fields:
And I have another db table containing the fields nameprod_user and priceprod_user.
I have a form in a page where the user select the product using a select dropdown. The dropdown is populated with a recordset on the product table.
I know how to put the select value in a database field, but in this case I need to put the select value along with another value.
The select dropdown has the value set to name_prod.
I need to select also the price_prod value.
Then I need to put the two values (name_prod and price_prod in the related db fields: nameprod_user and priceprod_user).
I can do this easily using the good-old ADDT from Interakt (using Multi-field dropdown server behaviour).
How can I do this with data bridge?