For my layouts, I have a sidebar with the navigation. Now I would like to show some lists but with Filemaker 10 it's impossible to have a fixed sidebar like the header or footer. So I have to use the form view to show the list but how? A portal which points on the same table can't work.

Maybe I could create a new table but I don't know how to set the relationship

Thanks for the help

by

ChiSao

Found possible solution:

creating new table (Listtable) with one field: List id

on the table (invoices) which, I would like to use for showing a list, I've added a the foreign key List id (global) --> create a many to one relationship to the table "Listtable"

Now I could create a Layout based on the Listtable and insert a portal which points to "Invoices"

It's not nice but it works.

Is there another better solution?

Found possible solution:

creating new table (Listtable) with one field: List id

on the table (invoices) which, I would like to use for showing a list, I've added a the foreign key List id (global) --> create a many to one relationship to the table "Listtable"

Now I could create a Layout based on the Listtable and insert a portal which points to "Invoices"

It's not nice but it works.

Is there another better solution?

There is a found-set paged portal solution that is based on my "Virtual List" technique. Maybe I'll post an example.

A virtual list has a utility table holding fixed record set (no create, no delete) that has a field "Index" simply holding the values 1 thru N where N is the total record count.

A second field holds a calculation like this:

GetValue( $$array; Index)

In your case the calc would be

Let( RN = get( RecordNumber);

GetNthRecord( Contact::ContactID; Index + RN -1)

Sorry, that is incomplete but may give you enough to get started with.