Hi everybody,

I am building a relational database that will be used for linguistic research. I want to have a many-to-many relationship between 'Sentences' (which is a table full of the different sentences that have to be analyzed) and 'Glossers' (which is a table in which I want to place all the different people that are working on a sentence). Its many-to-many because the same person can analyze different sentences and a single sentence may have looked at by different people.

So far I have used a join table, 'Join', which holds two foreign keys '_FK_Sentence' and '_FK_Glosser'. The primary keys are in respecively the Sentences and Glossers table. I think I have draw the relationships correctly, but I am unsure how to proceed from here.

Do I need to make a portal in table 'Sentences', and then put the foreign key '_FK_Glosser' along with for instance the name of the glosser from 'Glossers' in there? But then what about the communication between 'Join' and 'Glossers'? Do I need a portal there as well?

I apologize for my very basic questions, but if anybody can explain this to me or refer me to a place where this is properly explained, I would be very grateful!

Thank you! Annemarie.

Take a look at the demo file posted here:

http://www.fmforums.com/forum/showpost.php?post/246136/