January 30, 201114 yr I am running FM ADV 11 on Mac OSX I have a table: Members PK_Members LastName etc I created a duplicate of Members called Members_Portal I want to put a portal (which shows only the Member Name) on the left of a Members form so that a user can scroll the portal, select a member and when selected, the form will change to show the detailed, selected member information. I Joined Members and Members_portal with a "X" join on their PK_Members fields I converted the portal field (Name) to be a button that has a GTRR to Members. The portal is based on Members_Portal It "Looks" good. But, clicking the member does nothing? Got any ideas? Thank you. Ron
January 30, 201114 yr Author I am running FM ADV 11 on Mac OSX I have a table: Members PK_Members LastName etc I created a duplicate of Members called Members_Portal I want to put a portal (which shows only the Member Name) on the left of a Members form so that a user can scroll the portal, select a member and when selected, the form will change to show the detailed, selected member information. I Joined Members and Members_portal with a "X" join on their PK_Members fields I converted the portal field (Name) to be a button that has a GTRR to Members. The portal is based on Members_Portal It "Looks" good. But, clicking the member does nothing? Got any ideas? Thank you. Ron OK. I got it to work. BUT, the problem now is that when I see a Member record and click a DELETE button (which deletes the record) it, of course, deletes ALL records (I presume because of the "X" join). How do I get around this? Thanks
January 30, 201114 yr when I see a Member record and click a DELETE button (which deletes the record) it, of course, deletes ALL records (I presume because of the "X" join). There is no "of course" about it. It looks like you have enabled the 'Delete related records…' option in the relationship definition.
Create an account or sign in to comment