Portal instead of columnar list...?

[dimension]

...Is there a way of using a portal instead of the traditional columnar list to display records (all records of a single table) on a layout?

Frank.

[Inky Phil]

Hello Frank

relate the table to itself using a cartesian (x-type) join and then use this relationship as the basis for your portal.

You should see all the records in the table through that portal.

HTH

Phil

[dimension]

...Hi Phil, all I'm getting is a single record, which scrolls through with the mouse as normal, but still 1 record - not a list...

Frank.

[comment]

Most likely the fields in the portal are not from the same TO as the portal.

[Inky Phil]

or possibly your portal is set up to only show 1 row...right click it in layout mode and check under portal setup

Phil

[dimension]

...Now I've got a massive headache(!) - any examples - P L E A S E !

Frank.

[Inky Phil]

Better still can you zip up a clone of your file and attach it here. That way we can have a look at your problem

Phil

[dimension]

...Well, after much thought, I finally worked it all out;

Firstly, the layout to show the portal is pointed to the table which contains a single record.

The portal itself points to a self-join of the table, now called , - as do the portal's fields.

The table contains 2 fields only; &

is calculated to match & vice-versa.

Once is given a value of 'x' (this must be constant) it is automatically related to the single 'x' record in the table.

The portal layout now shows all records matching the single 'dummy' record.

The 'X' self-join of the tables are;

=

AND id # id

Hope this makes sense! It works like a charm, and in my opinion looks better on the layout as a portal instead of the standard list...

Frank.

Edited May 13, 2007 by Guest

[Vaughan]

In mulit-user, when a user opens a record (to edit it) the first record in the portal will also become locked -- this will become a problem, because it'll always be the same record, the first in the portal.

[dimension]

'multi-User' is not a problem for me - the design is for single-users only...

Frank.