Location:  Forum Index » Database Schema & Business Logic » Relationships » Quick Help on Simple Relationship



359 Views    -    1 Replies


Username Post: Quick Help on Simple Relationship        (Topic#213745)
Your continued generosity and support of FMForums is greatly appreciated.
NateBBB 
newbie
 Posts: 4

Loc: USA
Post Rank (AVG):
            


FMP: 9 Advanced
OS: Mac OS X Leopard
Skill: Intermediate



Tweet This! Tweet This Post!
   This is NateBBB's fourth post.
03-09-10 02:48 PM - Post#352114     - Post Rank:             


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.?










Your continued generosity and support of FMForums is greatly appreciated.
efen 
master
 Posts: 334

Loc: England
Post Rank (AVG):
            


FMP: 8.5
OS: Windows XP



Tweet This! Tweet This Post!
03-10-10 08:17 AM - Post#352189     - Post Rank:             
    In response to NateBBB

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










Icon Legend Permissions Topic Options
Print Topic

Email Topic

359 Views
Welcome Guest...
Enter your username and password to login. If you do not have a username you can register one here

Username

Password

Remember me. Help



Forgot Password...


Quick Links
Recent Posts
Active Topics
No Replies
Recent Files
Functions & Scripts
FileMaker Pro Help
FileMaker on Twitter
FileMaker Marketplace

Custom Search

Find FileMaker Developers

Don't have time to wait,
hire a developer now!
Recent Members
Welcome them to our community!
Find FileMaker Jobs

Want a new career?
Find your new job now!
Joy of Tech
Latest Joy of Tech!

Recent Topics
Recent Hot Topics
Contribute
With your generosity we can make some real magic happen!. Support your favorite online FileMaker community...
FM Forums.com


Click here...

Or a Donation of any amount.


Thanks for your support!

Active Blogs
0 Recent blogs:
People to Post Lately in this Topic
NateBBB
efen
Location:  Forum Index » Database Schema & Business Logic » Relationships » Quick Help on Simple Relationship
FM Forums Advertisers


FusionBB™ Version 3.0 FINAL | ©2003-2010 InteractivePHP, Inc.
Execution time: 0.97 seconds.   Total Queries: 39   Zlib Compression is on.
All times are . Current time is 09:09 AM
Content ©1996-2008 Ocean West Consulting, Inc. All Rights Reserved
Ocean West Consulting, Inc. can not and will not be held responsible for any of the contents in this site.
FM Forums™ is a trademark of Ocean West Consulting, Inc an independent entity, not affiliated with FileMaker Inc.
FileMaker® is a registered trademark of FileMaker Inc.
Top