Gogargirl Posted December 4, 2002 Share Posted December 4, 2002 Not sure if this one belongs here or in the Portal Forum.... I have a portal on my layout showing 20 rows, which is the maximum number of related records. For design reasons, I want to "split" the portal, i.e. have two portals showing 10 records each. Now obviously if I just put another portal on the layout, it'll show the same related records as in the first portal. Is there a calc I can use to get the 2nd portal to show the records from row 11 onwards from the 1st portal? Something like "GetPortalRow" - which I don't think exists? I don't want to use a scroll bar, as I want the records visible at all times so that the user is able to click on any one of the portal rows and then go to the related record. Any ideas please? Link to comment Share on other sites More sharing options...
djgogi Posted December 4, 2002 Share Posted December 4, 2002 Simply define in your master an value list "PortalList" as use only related values (from your original relationship) from field recordID (if you don't have it define it as serial number text for ex ID001 ect) Now, allways your master file, define an unstored calc: restOfPortal=Right(ValueListItems(Status(CurrentFileName),"PortalList"),Count(YourOriginalRelationship::recordID)-10) Finally define the second relationship using field restOfPortal in your master file and recordID in related file. Put the second portal beside the original one. Dj Link to comment Share on other sites More sharing options...
CobaltSky Posted December 4, 2002 Share Posted December 4, 2002 This is an excellent tip, but it will be necessary to use the 'RightWords' function, not the 'Right' function, or else it will not work as expected. I'm sure that is what Dj had in mind! Link to comment Share on other sites More sharing options...
djgogi Posted December 4, 2002 Share Posted December 4, 2002 Ooops! Tanx Ray Dj Link to comment Share on other sites More sharing options...
Gogargirl Posted December 6, 2002 Author Share Posted December 6, 2002 It works like a dream - many thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7904 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