ZenDiagram
Registered User.
- Local time
- Yesterday, 23:12
- Joined
- Aug 28, 2018
- Messages
- 37
I built a database that works pretty well but I'm realizing that my original db table design & relationships were not designed well.
I am going back to the basics. I would love some feedback.
purpose of the database:
keeping track of land owners in a town who have one or more properties under a certain tax classification.
reports generated from this db are used as applications. Each land owner must reapply every year for this tax status. I print the applications with each owner's mailing info and info for each of the properties they own, send it to them, and they return it with any changes to the information- which I then update in the db.
I have a preliminary table hierarchy outlined with photo attached.
tbl_Owners-->tbl_Properties--->tbl_Fiscal Year
Tbl_Owner: Active (Yes/No), Owner first name, owner last name, mailing street #, mailing street name, Phone #, etc.
Tbl_Properties: Property street #, property street name, total Acres, etc.
Tbl_Fiscal Year: This goes on the application (access report) and I'm not sure how to incorporate it into the tables. Applications are sent out once a year. This year we would print applications for fiscal year 2020. So it changes every year.
How should connect these tables?
Thanks!
I am going back to the basics. I would love some feedback.
purpose of the database:
keeping track of land owners in a town who have one or more properties under a certain tax classification.
reports generated from this db are used as applications. Each land owner must reapply every year for this tax status. I print the applications with each owner's mailing info and info for each of the properties they own, send it to them, and they return it with any changes to the information- which I then update in the db.
I have a preliminary table hierarchy outlined with photo attached.
tbl_Owners-->tbl_Properties--->tbl_Fiscal Year
Tbl_Owner: Active (Yes/No), Owner first name, owner last name, mailing street #, mailing street name, Phone #, etc.
Tbl_Properties: Property street #, property street name, total Acres, etc.
Tbl_Fiscal Year: This goes on the application (access report) and I'm not sure how to incorporate it into the tables. Applications are sent out once a year. This year we would print applications for fiscal year 2020. So it changes every year.
How should connect these tables?
Thanks!