Good morning,
I am helping my HOA build a simple database for tracking HOA Members and the properties they own in the HOA for billing purposes. We have almost 300 owners and close to 800 lots to keep track of, and our bookkeeper's paper system is very limited in its functionality.
Here's what I have so far:
TMember table
- MemberID (auto number, primary key)
- LastName
- FirstName
- StreetAddress1
- StreetAddres2
- City
- State
- Zipcode
- PrimaryPhone
- SecondaryPhone
- Active
- CommonsRestriction
- Notes
- Attachments
TLot table
- LotID (short text, primary key)
- LotOwner (number)
- SitusNumber
- SitusStreet
- PPIN
- LastTransactionDate
The MemberID field from the TMember table is related to the LotOwner field in the TLot table as a one-to-many relationship. This allows me to associate multiple lots to one owner. Unfortunately, we have a few instances where we have a lot(s) with multiple, unrelated owners. Each of these owners needs to be charged HOA dues, and thus one lot may need to be associated to more than one member. My database in its current state will not allow a lot to be associated to more than one member. How do I make lots and owners a many-to-many relationship so that I can charge HOA dues based on how many lots each member has in their name?
Thank you!