newbie here, need a little help with a relationship auto-fill
I've got two tables. 1 is a list of properties and one is a contact list. The list of properties imports from an excel spreadsheet. I created a button on the property list that runs a script to create a contact based on the information from the property list.
BUT a contact might have more than 1 property and I don't want to create contacts based on every property. I put a yes/no dropdown list on the property page and thought that the script should basically be: if "yes" create new record on contact table, field x = field x .....
So I need help doing that, also the issue that doing that successfully would duplicate contacts if more than one property is owned by the same person.
From the contact view, I want to be able to see what properties the contact owns - probably through a portal I guess.
New to filemaker, first database design. thanks in advance.
using FM 11 pro advanced.