AnsweredAssumed Answered

Updating inventory prices from invoices for current values

Question asked by KevinSalisbury on Apr 4, 2011
Latest reply on Apr 4, 2011 by philmodjunk

Title

Updating inventory prices from invoices for current values

Post

Hi,

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!

Outcomes