Problem Relationships:

I have three tables:

Table 1: Pizza Restaurant Locations

Table 2: Pizza Orders Made for each location

Table 3: Menu Items(Cheese, Olive, Pepperoni)

I want to build a report via a Portal on a layout for Table 1. Showing all the menu items ordered for that restaurant including the quantity totals for each menu item for that restaurant .

What is the best way of doing this.?

You should be able to adapt comment's join table_demo file:

http://www.fmforums.com/forum/showpost.php?post/246136/

to fit your needs