1 Reply Latest reply on Feb 26, 2011 9:48 AM by Sorbsbuster

    updating prices from inventory to sales



      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