Jump to content
Sign in to follow this  
dimension

Portal instead of columnar list...?

Recommended Posts

...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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

...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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Phil

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

...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.

Schema.png

Edited by Guest

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Frank.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.