Updating inventory prices from invoices for current values
I'm relatively new to filemaker and am having trouble figuring this one out! I have a parent table called "INVENTORY" that serves as a reference to "INVOICE ITEMS" and are related by a common "product ID". As a user enters products in an Invoice, related values (prices, product weight, qty's, etc) are lookedup and are stored in the "INVOICE ITEMS" table. The problem I'm having is creating a script or relationship that will update information in the INVENTORY table, so that it reflects current product prices. I've tried adding a sort to their relationship and making "price" in the INVENTORY table with a calculated value "Last ( INVOICE ITEMS::price) but it doesn't seem to work. I really appreciate your help!