AnsweredAssumed Answered

Turn a number in a field into that many related records

Question asked by waters1111 on Nov 21, 2018
Latest reply on Nov 24, 2018 by waters1111

I have 2 tables. Table1= Quantity, Table 2= Rows. 

 

Quantity Table has 1 number field called Qty. When I put a number in this field, I want to create that many rows in table 2(rows) with the corresponding primary key from table 1.  Say i enter 25. I would like 25 rows to appear in table 2.

 

If I then reduce 25 to 20, I would like a pop up to show me all 25 rows with a selection box with the option of which 5 of the 25 to delete. 

 

Can someone help?

 

Thanks!

Matt

Outcomes