Jump to content

Cartesian Join?


ron G
 Share

This topic is 4391 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4391 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.