AnsweredAssumed Answered

Filter Table Occurrence contents with Many-to-Many Join Table

Question asked by FM_Rookie on Aug 30, 2011
Latest reply on Aug 31, 2011 by philmodjunk

Title

Filter Table Occurrence contents with Many-to-Many Join Table

Post

I am a relative FM newbie, so please speak slowly...

I have separate tables so users can set up their own groups for a contact to be a member of (actually using a SQL DB) & edit them.

Contact::ContactID -< ContactGroupMember::ContactGroupMemberID >- ContactGroup::ContactGroupID

I need a table occurrence of "Contacts" that will take the contacts that are volunteers & display only "Volunteers."  This table occurence result will then be used in a script.

Thanks in advance.

 

Outcomes