Summary Layout

[spiggott]

I have a database with three related tables: assets, troubles, and changes. I would like to create a "summary" layout that will show me the 10 most recent records from each of the three tables so I can see, at a glance, the most recent entries into the database. Does anyone have an idea of the best way to go about this? Thanks for any help you can offer.

[transpower]

Set up a fourth related table and have three portals, each reverse sorted by date, and each with 10 rows.

[spiggott]

I'll give it a try. Thanks a lot!

[spiggott]

I can't seem to get the related table set up correctly. Any pointers?

FWIW, the relationships of my three existing tables is based upon the "asset_id" field in each. "Asset_id" is a unique, auto-enter serial that is created when I add an asset record.

Thanks again.

[transpower]

Then use Asset_id in the fourth table as your key.

[spiggott]

Okay, so I'm new to Filemaker which I'm sure is painfully obvious. I created a fourth table, "summary", with the field "asset_id". But do I need to set that as a looked-up value to get the data from the other tables? Otherwise, when I create the portals on the summary page they are empty because there apparently are no related records.

Sorry if I'm being obtuse, this just seems so foreign after working with MySQL previously.