June 24, 200817 yr I have a layout with two tabs. I was wondering if it is possible to have a form view layout on one tab and then a list view layout on the other tab.
June 24, 200817 yr Author That's what I ended up doing but the portal does not show all the records. Maybe I created the relationship incorrectly...
November 9, 200916 yr I'm dealing with the same challenge. Is there a way to show all records in a portal, rather than just the one related to the current record??
November 9, 200916 yr To show all records, create a relationship based upon the last join option (X) the cartesian product. Then place a portal based upon that relationship on your layout. The fields you use in the join don't matter (and don't have to match nor have data in the field) except you can't use globals, containers or unstored calculations.
November 9, 200916 yr Thanks so much! Being a newbie - didn't follow exactly what you were telling me to do, but the (x) factor seemed to work! BTW - Cartesian?
November 9, 200916 yr cartesian . However, if you search FM Help for cartesian, you won't find it. FM says little about it. If you search for 'About relationships using comparative operators' it shows the X and says all values in left match all values in right. But I can't find any place which goes into specifics about the match field stipulations of non-global, not container etc. I'm unsure if I ever read it in Help or just found out on forums.
November 9, 201015 yr Newbies I too would like to create a portal on a tab control to show all records (in this case a global To-Do list for all clients) but your explanation totally went over my head. Can you provide a more simplistic, step-by-step explanation please?
Create an account or sign in to comment