1 Reply Latest reply on Aug 6, 2014 1:01 PM by philmodjunk

    creating connections in filemaker pro 13

    khutchison

      Title

      creating connections in filemaker pro 13

      Post

           I use filemaker pro 13 and use two startups inventory and invoices.  I have products that I sell that are defined in invoices and I have included all these items by exporting them and integrated them into inventory.  I want to create a relationship between both databases and I don't know how. I need to know how many products I sill have in inventory and when I sell one inventory  should reflect that sale and what's left?

           If anyone has a solution it would help!

            

           Thanks

           Nath

        • 1. Re: creating connections in filemaker pro 13
          philmodjunk

               merging two starter solutions is a far from simple process. In theory, the Transactions table in Inventory can be set up as the Invoice LineItems table in Invoicing so that selling an item on an invoice automatically reduces your inventory by the quantity sold. But it would not be a simple process, especially if you are not pretty familiar with how to design and modify databases.

               Here's a thread on how the "line items" (called Invoice Data in your starter solution) table used in invoicing can be set up as the transactions table in an inventory system: Managing Inventory using a Transactions Ledger