S
skk
I would like to batch update or create template table when user press the
button. For example, in the main screen user will pick the "ProductType" and
"PeriodDate" it will create table like below. If user picks "ProdA" I want
to loop through 3 times & create 3 template records if "ProdB" 7 records etc.
My objective is to create template table with zero $ for cost & this field
will be updated by user input screen later. Code sample or suggestion will
be appreciated. Thanks!
ProductType:
"ProdA" has 3 products (A1,A2,A3)
"ProdB" has 7 products (B1,- B7)
ContractID ProdID ProductType Cost PeriodDateID
from Main scr) (tblProd) (tblProd) (tblProd) (from Main Scr)
---------- ------ ----------- ---- ------------
1 1 P1 0.00 1
1 2 P2 0.00 1
1 3 P3 0.00 1
button. For example, in the main screen user will pick the "ProductType" and
"PeriodDate" it will create table like below. If user picks "ProdA" I want
to loop through 3 times & create 3 template records if "ProdB" 7 records etc.
My objective is to create template table with zero $ for cost & this field
will be updated by user input screen later. Code sample or suggestion will
be appreciated. Thanks!
ProductType:
"ProdA" has 3 products (A1,A2,A3)
"ProdB" has 7 products (B1,- B7)
ContractID ProdID ProductType Cost PeriodDateID
from Main scr) (tblProd) (tblProd) (tblProd) (from Main Scr)
---------- ------ ----------- ---- ------------
1 1 P1 0.00 1
1 2 P2 0.00 1
1 3 P3 0.00 1