10 Replies Latest reply on Mar 30, 2017 8:59 AM by mike13a

    Report based on records from multiple tables in Extrernal Databases

    Shoreline

      Hi Filemaker Friends,

       

      I have one Database that has all of my Customers, Suppliers & Products. (DB A)

      I have a couple of databases that all reverence the same Customers, Suppliers & Products (DB A).

      Orders get places in my other Databases.

       

      Now I have been asked to do a report to show how many orders we have placed per Supplier accross the board from all of the databses where the Orders are placed.

       

      I have been manually exporting the data out of each database and importing it into one table into (DBA).

       

      Is there an easier way for me to do this?