Jump to content

Why doesn't this Members -- Candidates popup work?


ron G
 Share

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

Recommended Posts

I am using FM 11 Adv in OSX

I am stuck. Here is the layout.

Tables:

See Diagram Below

Narrative:

I have an organization of 100 members. Each candidate for the organization needs sponsorship from 3 members. And of course, a member may sponsor more than 1 Candidate. (Sounds like a many to many relationship to me?)

On the Candidate layout (based on the candidates table) I am trying to put 3 dropdown boxes in which each will show all the members for the users selection.

I have tried:

Putting the KF_Candidates in the Members table to get a 1:many relationship. Didn't work.

I have tried:

Creating a many to many relationship with a MemberLink table between Members and Candidates --- as in ---

MEMBERS----->>MEMBERLINK<<-------CANDIDATES

(It 'kind of' works. As long as I don't 'include value from 2nd field)

Didn't work.

I have tried:

Created a Cartesian relationship between Members and Candidates and then based my popup on Members…. Didn't work.

In all the above, I get a single, member record in the popup.

Ideas appreciated.

Thanks

ishot-490.jpg

Link to comment
Share on other sites

Not sure what "didn't work" means. This is a many-to-many relationship. so it would probably be best to use a join table.

However, it sounds like your issue is with the value list: in order to select from all members, your value list should be defined to 'Include all values' from the MemberID field in the Members table.

Link to comment
Share on other sites

This topic is 4370 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.