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, 200620 yr by Guest

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

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

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.