AnsweredAssumed Answered

many to many relationship

Question asked by Dasa on Feb 27, 2010
Latest reply on Mar 7, 2010 by Dasa


many to many relationship


Hi, I am an amateur using FM 10 on Mac 10.6

I have a database for art objects with these tables:

art object (has one contact/location at a time) WORKING

contacts (can have many art objects at a time) WORKING

exhibitions (can have many objects and an art object can have many exhibitions) NOT WORKING

How do I make a functional many to many relationship between art objects and exhibitions?

Each table has one ID field.

Thank you!