many-to-many and calculated field in a portal

[stenov]

Hi...sorry for my English (I'm italian...),

ok, my problem is:

3 files:

RawMaterials (RMID, RMName, RMPrice)

Products (PrID, PrName, PrPrice, RMID, RMAmount)

Orders (OrID, CustomerID, PrID, PrAmount)

These 3 DB are in a relationship many-to-many with 2 DB linking by portals:

LineItems RM/Product

LineItems Products/Order

If I've many Orders that contains same Product, I want to know how many Amount of RawMaterial I need to produce and deliver the Orders containing that Product (in Italian is FABISOGNO, I don't know in English!!!)

All the ralationships works great, but I've no idea like get at, may be to have a calculated field, wich arrange PrAmount in the OrderDB to each RMAmount in the portal containing LineItem RM/Products.

I hope someone realized something....thanks for any helps....

Stefano Novello

[stenov]

Let's try with example:

Product A (from ProductDB) is composed by:

RawMaterial A (from RawMatInventoryDB)

RawMaterial B (from RawMatInventoryDB)

RawMaterial C (from RawMatInventoryDB)

Product B (from ProductDB) is composed by:

RawMaterial B (from RawMatInventoryDB)

RawMaterial C (from RawMatInventoryDB)

Order A (from OrderDB) is composed by:

Product A (from ProductDB) -> Amount X

Product B (from ProductDB) -> Amount Y

Order B (from OrderDB) is composed by:

Product A (from ProductDB) -> Amount Z

Product B (from ProductDB) -> Amount W

In the LineItemDB Product/Order I can see in a portal the RawMaterials wich composed each Product.

At tath point the question is:

how can I calculate the TotalAmount of each RawMaterial needed to deliver both Orders A and B with Amount X,Y,Z,W of Product A and B??? In wich DB must be inserted a calculated field tath combine RMAmount x Product to ProdAmount x Order having RMTotalAmount? And wich kind of calculated field must be?

thanks, thanks, thanks for helps....