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

[ron G]

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

[comment]

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.

[ron G]

Got it to work. (This is embarrassing). I had somehow declared the calculated Name_Last_First field as numeric. When I turned it back to 'text' everything worked as expected.