R
Rene
I need to create a database to track information about a building complex
with 400 residential units. I need to track the turnover rate for the
apartments over the years as the vacancies change almost every month. I also
need to track individual tenants' contributions to a legal fund (check
numbers, amounts, dates, etc.), their attendance at meetings, etc. Tenants
may move from one apartment to another in the same complex. I think I will
need one table that will probably almost never change, with the
characteristics of the apartments. Then another one for the tenants
themselves, to track financial contributions, and then at least a third one
to track attendance at meetings. I need help setting the relationships
among, and properties of, these tables and running reports. Would I need any
more tables?
with 400 residential units. I need to track the turnover rate for the
apartments over the years as the vacancies change almost every month. I also
need to track individual tenants' contributions to a legal fund (check
numbers, amounts, dates, etc.), their attendance at meetings, etc. Tenants
may move from one apartment to another in the same complex. I think I will
need one table that will probably almost never change, with the
characteristics of the apartments. Then another one for the tenants
themselves, to track financial contributions, and then at least a third one
to track attendance at meetings. I need help setting the relationships
among, and properties of, these tables and running reports. Would I need any
more tables?