FMPRO-L Archives

July 2010, Week 4

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Richard S. Russell" <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Wed, 28 Jul 2010 00:49:56 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (13 lines)
On 2010 Jul 27, at 23:48, Barbara Passman wrote:

> ... when I choose  Table(grid) view of the same layout, only one of the four values displays, no matter how large I make the field ...
> 
> What can I do so that all the related values display in the table view?
> What am I doing wrong?


Nothing.

FileMaker Inc. provided Table View as a service for people who wanted to see what their database would look like if it were a spreadsheet. But spreadsheets, of course, do not permit 1-to-many relationships, so what you get in Table View is a look at ONLY the topmost value in your portal — Fido, but not Kitty or Birdy. (This is, incidentally, the same value you'd get if you moved that field from inside the portal to outside of it. It's typically the 1st related record created, unless you've specified a different sort order either via the relationship or the portal definition.)

To get the appearance you seem to be shooting for, stick with List View, string all the fields out horizontally, but put the pet names in a portal expanded vertically to at least 4 rows. This will waste a lot of screen space, but it'll sure make it clear where each new record starts.

ATOM RSS1 RSS2