Viewing more than one related record in Table View or on Reports

[Jenna]

Hello helpful people,

I manage a few different FMP databases and have noticed that when I "View as Table" or create a report, only one of the related records tied to a given record is displayed (the earliest entered one, I think). For instance, I have a table for "customers" and another for "checks received." It is a one-to-many relationship, since some customers divide their one-time payment into more than one check (it's a long story). On the main layout where I enter the data, I have a portal to the "checks received" table, and that's where I enter the different checks (their amounts, numbers, etc.) I made it so that I can enter up to four checks (check records) in the portal.

When in Form View, of course I can look at the portal and see that John Jones paid with two checks (and what the amount and check # of each was), but when I switch to Table View (or make a report), all that appears with his contact information is his oldest check record. I want to see all of them, the same way I do in Form View (only as a spreadsheet/report, each check record in its own row).

Is there a setting I'm missing? It seems like this should be easy, a matter of adjusting FMP preferences, but I can't figure it out.

Anybody know?

Thanks!

[bruceR]

Nothing to change. That's how table view works. Don't use table view if this is important to you.

[lawaid]

Hi:

Portals can not be used in Table view ... at least not within the "rows."

However, you can have a portal in the Header portion of Table view. As you click on different records in the rows, your portal will display the related records for the current record.

Maybe that could work for you ...