AnsweredAssumed Answered

[Question] Is it possible to create many-to-many relationship within a single table?

Question asked by TaylorJansen on Feb 8, 2012
Latest reply on Feb 9, 2012 by philmodjunk

Title

[Question] Is it possible to create many-to-many relationship within a single table?

Post

Hello. I am a new user to FileMaker. I have some experience on Microsoft Access too. My question is as the title:

Is it possible to create a many-to-many relationship within a single table?

I am thinking of a database that has a table containing all sorts of personnel infomation. Each personnel has a different role. Personnels are inter-related in terms of a few number of ways.

To simplify it, I have 3 types of personnel and they are inter-related. That forms a triangular relationship among them. The relationship gets into a circle that FileMaker does not allow.

How can I design the relationship and what additional fields I need to achieve the task?

I would like all related personnels of a particular person to be shown up on a portal for that person.

Many thanks. 

If no solution, I may need to create as many table as the number of roles the personnel might have.

Outcomes