How to calculate Latest Supplier and Latest Cost?
i have a Products Table with fields that i would like to tell the latest supplier and latest cost of the product
latest_supplier = the current supplier where i bought the product
latest_cost = the price of the product from the current supplier
i will be using a Purchase Invoice Form with Portal Line Items to enter bought Products from a supplier
Sometimes another supplier will give you a better price, and you will have a new supplier.
The Products last_supplier will be different or the same depending on where you bought the products.
what is the basic way to do this?