1 Reply Latest reply on May 15, 2013 3:17 PM by GuyStevens

    Determining Table Relationships



      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.