This topic is locked

Add Multiple Records

2/7/2019 4:37:56 AM
PHPRunner General questions
M
maaroufkamel author

Dears

thanks for PHPRunner team
i need help in the following
i have these 3 tables

table1 Products_Setup with fields [Product_GTIN] , [Product_UPN]

table2 Stores with fields [Store_Code] , [Store_Title] >>> have 100 stores records

table3 Product_Balance [Product_GTIN] , [Balance] ,[Store_Code]
i need when i add new product in table1 Products_Setup add event to insert in table3 Product_Balance [Product_GTIN] , [Balance] ,[Store_Code]
example: i need inserting balance 0 by default for the new added product to all stores in table3

to be cleared generate records by stores_Code for the new product by Balance 0 in table 3
Thanks alot for any help