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.