Many to many

[musicarteca]

Sorry, I have done this in the past, but It has been a while, so I have forgotten. I have to do a M to M. relationship between to tables, I remember that I had to create an intermediate table, but then what? I am in FMP7, and the help and manual only explain single key or multi-key relationships.

Thanks a lot.

Edited January 16, 2006 by Guest

[Ender]

Perhaps you can tell us what the tables are that you're relating so we can be specific.

[RalphL]

See topic Complex Relationship Help Needed, Post#180289. I posted a sample file there.

[musicarteca]

Thanks for the responses, I already figured out. I was triying to design a M to M relationship between a contact table and a mailing list table. One mailing list has several contacts, and a contact can be in several mailing lists.