AnsweredAssumed Answered

Determining Table Relationships

Question asked by danadribben on May 15, 2013
Latest reply on May 15, 2013 by GuyStevens


Determining Table Relationships


     New FM 12 user trying to create a db for real estate prospects.  For background there is a resort with separate homesites for sale. Prospects can be generated by referrals from owners or brokers. They may also be generated after visiting the resort or after seeing web/print advertising.

     I am considering tables for contacts, prospects and resort visitors and am trying to determine which ( if any )  would have one to one relationships, or one to many relationships, or many to many relationships to determine whether to assign primary or foreign keys.

     Thoughts appreciated.