AnsweredAssumed Answered

Calculations with related tables

Question asked by erez on Aug 23, 2012
Latest reply on Aug 25, 2012 by philmodjunk


Calculations with related tables


I've an administration system for the reception of different shipments that permits the registry of different providers and their respective materials that they send to us and also the registry of every shipment, we charge the providers for the service a different quantity per ton even if they send us the same material, my problem its that in the shipment registry view i can choose the provider, i register the weights of the shipment and the material they sent but i want that when i select the provider automatically i can view the materials we have registered to him and after choosing the material the system takes the cost per ton and the tons registered and calculates the cost of the reception. How can i do that?

Thanks for the help and sorry for my bad english!