AnsweredAssumed Answered

Auto Calculation question on related table

Question asked by henryhu91 on Apr 16, 2013
Latest reply on Apr 19, 2013 by philmodjunk

Title

Auto Calculation question on related table

Post

     Hello FM users, 

     I have a question on auto calculation field.

     I'm using Inventory FM starting point in my database. 

     I've Product table, Transaction table and Product ID is unique key for relationship. 

     Transaction table have a field called "Transaction Type" to determine what type of transaction 

     for example. Order, Invoice, Receive, and etc. 

     If a record from transaction table is order, my staff will input price, quantity and shipping location.

     Product table have a field called Price field. 
     I would like to auto fill Price field to update automatically from the price field that latest order price that my staff ordered. 

     any help is appreciated. 

     Thanks

Outcomes