Your Knowledge Base has moved to the new Help Center.  Check out the release notes for details. And don't forget to update your bookmarks and in-house documentation before May 28.

Many to Many

 

The Many-To-Many relationship is one in which the page and sub-page are related via a common table which stores a Foreign Key referring to both the page and sub-page tables.

See Relationships > Many-To-Many

Example

Group Participants: Each Group may have many Participants and Participants may be in many Groups.

How to Configure

The Filter_Key is a foreign key on the primary table that stores cross-referenced records on the select from page.

Actions and Permissions

You must grant at least Read permissions to the sub-page before anyone can see it.

The Add button may be displayed for this relationship type by granting "Full" permissions. For this to work, the Foreign Keys in the database must actually form a many-to-many relationship.