AnsweredAssumed Answered

updating prices from inventory to sales

Question asked by rickremmy on Feb 25, 2011
Latest reply on Feb 26, 2011 by Sorbsbuster


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