AnsweredAssumed Answered

Create new records in seperate table by found count?

Question asked by JessOttman_2 on Aug 7, 2012
Latest reply on Aug 8, 2012 by mcward9884

Title

Create new records in seperate table by found count?

Post

 Hi,

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...

 

untitled.JPG

Outcomes