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.