I am trying to setup a many-to-many relationship. What I have is 3 tables, the Distributers, the Manufacturers and a join table. A distributer can represent many manufacturers and a manufacturer can have many distributors.

What I'd like to do is show a manufacturer record with a portal showing a list of it's distributers. And a Distributer record showing a list of it's manufacturers.

It would be ideal if you could create a new distributer record or a new manufacturer record by entering it in the portal. If this cannot be done this way, that's fine, but at lease be able to assign existing manufacturers or distributers to a record via the portal.

I've read the manuals, spend a couple of days on this and cannot seem to get this very basic (at least to me) relationship to work.

Either you can't get there from here or I am missing something...

Thanks-

See if this helps:

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

DOH! I see, The ID field... Thanks!