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!