AnsweredAssumed Answered

many to many relationships

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


many to many relationships


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!