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?