Nested Multi-Insert struggling to get the 2nd insert to work - thoughts / advise?

1

Hi,

I have two tables i want to insert fields into:

  1. the first - working perfectly inserts a number of fields including “fielda” into “Table1” (the values come from client side selection of attributes.

I then want to insert multiple "fielda"s into “Table2”, the multiple come from a query to “a separate table” which returns both the number of entries “fielda” to insert along with other data that needs to be inserted into each new line.

I cant get the 2nd repeat to work - i cant seem to store results of the query to “a separate table” in a way that the repeat will pick up each line in the query / array???

I’m not quite a newbie but still finding my way, so any thoughts or advice would be greatly appreciated.

Ive attached a screenshot … the bit i cant get to work is from query getrl2ids to the repeat below it

Screenshot 2020-09-11 172849
Screenshot 2020-09-11 172849593×625 45.3 KB

2

I believe what you want is to set the expression of your record_repeat2 to point to the results of getrl2ids, instead of the POST item.