Summarizing Data from Two Different Tables

[PutneyBob]

Greetings!

I have created a DB in FMP 8, that has many tables. Two of the tables (product_Sales and product_Inventory), both contain date, quantity, cost, etc fields.

How can I bring them together to show all of the inventory added and sales made during a particular time period? In other words, dump records from two diffenent tables into one big table to manipulate the data for reporting.

Thanks

[Ender]

Asked and answered here:

http://www.filemakertoday.com/com/showthread.php?t=12462