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

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