May 10, 200718 yr ...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.
May 10, 200718 yr 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
May 10, 200718 yr Author ...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.
May 10, 200718 yr or possibly your portal is set up to only show 1 row...right click it in layout mode and check under portal setup Phil
May 11, 200718 yr 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
May 13, 200718 yr Author ...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, 200718 yr by Guest
May 13, 200718 yr 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.
May 13, 200718 yr Author 'multi-User' is not a problem for me - the design is for single-users only... Frank.
Create an account or sign in to comment