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.
Are you a beginner at filemaker?
If so you might find a beginners screencast interesting:
And there are also other video's on my channel.
If you learn the basics you will be ble to see the relationships you need.