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?