I'm a beginner with MS Access hoping for some help with a database I am trying to create. This is (will be) a database of land parcels in a given area, and their associated landowners.
Here are my table fields, summarized in Excel (bold are my current PKs):
County Plat contains the parcels; the 'Owner' field is the listed owner for the land and could be an LLC, etc. so could have multiple individuals with varying stakes.
The Owners table associates these 'owners' with their corresponding landholders and their ownership percentage.
Finally, Contact List contains a given landholder's contact details.
So, for example, Parcel 0001 and Parcel 0009 are listed in County Plat as owned by Owner TOFU FAMILY TRUST, and the trust is listed in Owners as owned 50% by Jim Tofu and 50% by Bob Tofu. Their respective contact information is listed in Contact List.
Also, I would prefer not to edit the setup of the County Plat database if possible, as it comes from an outside source.
I would greatly appreciate any advice on how to best set up this database. I am currently getting errors trying to enforce referential integrity, and I'm pretty sure it is due to my lack of understanding of database design. Although I've read articles on it, I'm having difficulty applying those lessons to my own database. It would be really helpful to get some feedback from the pros on how to implement this.