As a workaround you could create a field in the parent table that is: List(ChildTable::PetNames). Then that field will contain the return delimited list you are looking for. Of course, in table view, you will still only see the first value, unless you click in the field so the values will display. So you might go one step fancier and replace the returns with commas:

Substitute(List(ChildTable::PetNames); "PP"; ", ")

You're still going to bump up against the limitations of table view though, I think.

Geoff

On Jul 28, 2010, at 12:48 AM, Barbara Passman wrote:

> I have easily related  two tables in a database.
> The one to many relationship works well and in List or Form view, the several values pertaining to a record in the related table  readily display that table's layout
> In the LIST view the field in the portal window is set to display four values.
> However 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
> 
> That is one table lists the pet owner by name and address
> The second related table lists the pets and their owner. 
> Many owners own more than one pet
> 
> In the pet owner layout I  added a portal to display the names of all the owners' pets 
> In the LIST or FORM view of  that layout, all the pets owned by an individual display.
> I,.e, 
> Owner: Jones, Alice
> Pets:    Fido
>             Kitty
>             Birdy
> 
> 
> But when I display the same layout in TABLE view, only one pet is listed even for people showing more than one pet in the List view.
> Owner               Pets
> _______________________________
> Jones, Alice     Fido
> ______________________________
> Smith, Clara     Goofy
> 
> What can I do so that all the related values display in the table view?
> What am I doing wrong?
> 
> Thank you
> Barbara P