CREATE Action: CREATE Transaction FOR EACH Account

yahya

Went trying to work out how the action works:

CREATE Transaction FOR EACH Account

The action in the first example will create as many instances of the Transaction object as there are instances of the Account object in the Context.

So tried to do it with the following which I have in my BSV:
BO=Warehouses
BO=ProductControl
BO=Product
Reference Attribute=ProductControl.Warehouses
Reference Attribute=Warehouses.ProductControl
Reference Attribute=Product.ProductControl

And this is my process:
CREATE ProductControl FOR EACH Warehouses

The reason I am doing this is I will create a product with the BO Product, this will then need to create a object in my ProductControl with reference to Warehouse for stock tracking in multiple warehouses.

After I have solved this then I need to look at when a warehouse is added after a product and then make sure the new warehouse is allocated to existing Products, but if I can figure out why this CREATE action is not working I should be able to sort out the second step quite easily.

rocketman

Not much info here - but here are some general rules.

When you want to iterate through the results of a query, It's best to put the CREATE Statement into a separate process.

Also you need to ensure you assign the BO you are creating to the top Level BO

so you would need something like

Process 1 WAREHOUSE_LIST
FIND ALL Warehouses
ProdControlCreate

Process 2 - ProdControlCreate
Create ProductControl FOR EACH Warehouses WITH ProductControl.Warehouses=Warehouses

yahya

Much appreciated for the help there, worked perfectly 😃