AnsweredAssumed Answered

many to many relationships

Question asked by ShelleyM on Nov 26, 2008
Latest reply on Nov 26, 2008 by TSGal

Title

many to many relationships

Post

Hi - I am a very new filemaker user and I have some questions about relationships. 

 

I created a database to deal with properties and contacts.  Each of these tables has a one to many relationship with three other tables (prop. notes, files and activities and contact notes, files and activities)and a many to many relationship with each other (I have properties with many contacts and contacts with many properties).  To resolve this many to many relationship, I set up another table I'm calling link.  Now the property table has a one to many realtionship with link and so does my contact table.  Will this work?

 

I have some concern about contacts that have no properties, will this be a problem for my database?

 

Any help would be much appreciated!

 

Thanks

Outcomes