Hello. I am trying to get build a calculation for a record that will look at the most current lineitem cost, in a portal that is related to that record.
What I have built is a Product table with all my current Products. I have then built a line item table related to the product table. The line item table is a date, name, quanity, and Cost table that is related to each product. Now when I reorder the Raw Material needed to build the product, it will update the product cost with the most current Lineitem's cost, updating the cost of the product.