Hello, I have made a simple workout database in FMP 8 and have three
tables in it a exercise table, joint table, and a daily workout table.
In the daily workout table I want to run a report with all the
exercises done that day that come from the portal (joint table) I
cannot figure out how to get a report that sorts by date from daily
workout but lists all the exerciese from the joint table and then goes
to the next date listing all its exercises. Can this be done?

In article <1162587561.391149.177400 (AT) e3g2000cwe (DOT) googlegroups.com>,
chrisforms (AT) mac (DOT) com wrote:

Never print a portal - if you are thinking you need to print a portal,
then you're in the wrong table for the report.

You should always print from the child table, using a relationship link
back to the parent to obtain data from the parent record(s) if needed.

In this case, it sounds like you should be printing from the "joint
table". If the date isn't already in this table, you can create a new
Calculation field that obtains the date from the "daily workout table"
(via a relationship) and then sort by that field.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)