dimension Posted May 10, 2007 Share Posted May 10, 2007 ...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. Link to comment Share on other sites More sharing options...
Inky Phil Posted May 10, 2007 Share Posted May 10, 2007 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 Link to comment Share on other sites More sharing options...
dimension Posted May 10, 2007 Author Share Posted May 10, 2007 ...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. Link to comment Share on other sites More sharing options...
comment Posted May 10, 2007 Share Posted May 10, 2007 Most likely the fields in the portal are not from the same TO as the portal. Link to comment Share on other sites More sharing options...
Inky Phil Posted May 10, 2007 Share Posted May 10, 2007 or possibly your portal is set up to only show 1 row...right click it in layout mode and check under portal setup Phil Link to comment Share on other sites More sharing options...
dimension Posted May 10, 2007 Author Share Posted May 10, 2007 ...Now I've got a massive headache(!) - any examples - P L E A S E ! Frank. Link to comment Share on other sites More sharing options...
Inky Phil Posted May 11, 2007 Share Posted May 11, 2007 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 Link to comment Share on other sites More sharing options...
dimension Posted May 13, 2007 Author Share Posted May 13, 2007 (edited) ...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 Link to comment Share on other sites More sharing options...
Vaughan Posted May 13, 2007 Share Posted May 13, 2007 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. Link to comment Share on other sites More sharing options...
dimension Posted May 13, 2007 Author Share Posted May 13, 2007 'multi-User' is not a problem for me - the design is for single-users only... Frank. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6192 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now