sabremm

Portal Summary Print Report

Discussion created by sabremm on Feb 1, 2018
Latest reply on Feb 1, 2018 by philmodjunk

I am fairly new to Filemaker and I inherited a database designed by a certified Filemaker developer.  I recently upgraded to Filemaker Pro Advanced 16 and I am currently adding several different types of reports.

 

Orders: Order Number, ClientName, Manufacturer, Order Date

 

Items (Portal): Description, Quantity

 

I need a report displaying/printing the following data:

 

Report for the period [start date ... end date]

Manufacturer

          ClientName1    

                    Description1     TotalQuantity1

                    Description2     TotalQuantity2

                         ....

          ClientName2

Manufaturer2

          etc. etc

 

Do I need a new table that combine these two tables with new relationships? If so, how would it be labeled.  Thanks for answering this vague questions.

Outcomes