Please help with Multirow variable set populate values

[Lisa Goldman]

Hello, 

I have been struggling to figure out how to link the two tables and get the data populated.  I hope someone can help. 

I would like to populate variables in a Multirow variable set based on the selection of the part number variable.  If a part number is selected, then populate the part description, Qty and Price variables  

Table: u_part_number

Columns: part_id   (Primary Key)

                 part_no

Table: u_part_detail

 Columns:  part_id (Primary Ke)

                   part_description

                   qty

                   price

Muti Row Variables:  Part No (Reference field)

                                    Part Description (Single text)

                                    Qty (dropdown)

                                    Price (dropdown)

[AshishKM]

It should replace with the new part description value.

Can you please share the screen shot of that variable configuration.

[Lisa Goldman]

Hi @AshishKM 

Here are the steps:

1. Created Part Number Table:

2. Created second table: Part Detail

3. MRVS variables:

4. Reference qualifier: