Create new records in seperate table by found count?
I have two tables in this particular database. in the first table i have records of products.If i do a find using the po number lets say i get 4 records. I would like to create the number of found records in another table afte clicking a button.
I have created a script but i have gone wrong and just need the best wat to do this. here is my attempted script
If i trigger the script the first time its fine if i do it again for the same found count its doesnt stop creating records in the other table...