Relationship not showing all records

[crow]

I have a layout called book. On this layout I have characteristics of the book. The bottom half of the layout is about pages of the book. In the pages area (body, viewing as list) I want all the pages to come up but I only get one. I have a book number that links the two.

I also have a layout that views as form. It has a portal showing the pages. This works perfectly fine. Both portal layout and view as list layout are setup the same but I only get one record with View as list.

Please Help. Thanks in advance.

[mr_vodka]

What happens when you take the form view that is working and then view it as a list. (go under view menu)

[bcooney]

View as list shows records from the table occurrence on which the layout is based. In your case, you probably are looking at a list of Books. Since Pages are children of Books, the only way to see multiple page records when on a layout based on Books is by using a portal (as you do in your Book Form).

You might consider a Page List view that includes the Book related fields.

[crow]

I have 24 records. Each one shows up in the list. Within each record I have a portal that still shows all the pages even in the View as list.

[crow]

Thats it. My list layout was based on book. I changed it to be based on pages and all is well. I still have to wrap my head around why this is.

Thanks!

Edited October 28, 2008 by Guest

[mr_vodka]

This means that the layout where you are having the issue is reflecting a different table occurence from the one that works, or the portal on it is not reflecting the same one as the one working.

[bcooney]

It is very important to grasp the concept of context in FM. In this case, the layout is based on a Book table occurrence. Therefore, you will see a list of book records. You may still want a list of Books, as well as a list of Pages.