AnsweredAssumed Answered

newbie here, need a little help with a relationship auto-fill

Question asked by GregSchnider on Aug 26, 2011
Latest reply on Sep 12, 2011 by philmodjunk

Title

newbie here, need a little help with a relationship auto-fill

Post

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.

PLEASE HELP

New to filemaker, first database design. thanks in advance.

using FM 11 pro advanced.

Outcomes