Cartesian Join?

[ron G]

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

[ron G]

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

[comment]

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.