Auto Calculation question on related table
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.