AnsweredAssumed Answered

Inventory Management

Question asked by BonnetBoutique on Aug 6, 2012
Latest reply on Aug 7, 2012 by philmodjunk


Inventory Management


We are using FileMaker Pro 12 for our inventory management at our retail shop. We'd like to take sales reports from our Square account and import them into our inventory database to reflect current quantities. For example, I want the items sold (which is shown on our Square report, which is an excel spreadsheet) to be automatically deducted from the units on hand in our FileMaker inventory. I have set up a table of our inventory, as well as a table for the Stock Transactions (which I have successfully managed to import my Square spreadhseet into). How do I get the two tables to talk with one another? They show that they are connected in the Relationships tab of the Database Management window, but I'm unsure of why it is not reflecting it in my units on hand. Help!