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

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.

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.