updating prices from inventory to sales
I have Sales and inventory data base that I have built with filemaker pro 8.5 for mac. I have used this database in one form or another since 1996. The one problem that I can not figure out is if I change the cost or price of an item in the inventory file, how can I get it to update in my sales file without rekeying in the product ID to make the data base relookup the values in the inventory file. My database is set up as follows
Inventory file linked to a product line items file
Line items file linked to sales file
any help would be greatly appreciated
Why would you want it to change the value in retrospect? Surely if a sale was made last year at last yera's price, then that price should remain?
Anyway: if you want to change them, find all the records in Sales that you want to change, click into the ProductID field, and select Records -> Relookup field contents...'