Portal workaround for List View limitation

[Stick]

How exactly would you implement this workaround? At the moment I have done it by creating a new empty table with a link field in it (set to 1) and a link field in the table I want the portal fields to come from - then set up a relationship between these link fields.

Then the portal layout is created from the new table.

Is this the right way to go about it?

[dbruggmann]

What do you want to show in the portal? Just all records of your first table? Create a selfjoin relationship between any two fields of your table (by adding a second table occurence in the relationship graph) and choose "X" as the join option (instead of the usual "="). Now every record is related to every other record in the table and you can build the portal layout in your original table.

[Stick]

Yes, that is exactly what I want to do.

Thanks!

[jonmais]

I've tried the self-join relationship exactly as you describe it but I'm still only able to view 5 records at a time from the layout which contains the self-join portal. Any clues as to what else I need to do?

[Stick]

If you are using a portal now, are you viewing as a form.

[dbruggmann]

Hello jonmais and welcome aboard

I'm not sure, if your problem is just an easy one: You can adjust the number of rows shown in a portal in Layout mode. Double click it and enter under "Format" the number of rows you want to show (you may need to adjust the height of the portal row on the layout afterwards). If there are more related records than portal rows, select also