Tables relationship for tenants association database

[Guest]

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?

 

[John Vinson]

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?

Rene, I answered one of the four other instances where you asked this
question. Since you don't have a real EMail address I just have to
hope that you can find this reply... or, better, the one where I spent
several minutes typing in a detailed suggestion for your table design.

If Microsoft's wretched excuse for a web-based newsreader is
responsible, consider going to http://groups.google.com and doing an
Advanced Search for your post.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Rick B]

How many times are you gonna post this?

 

[Guest]

I only meant to post it once. I selected the "Notify me of Replies" below my
post and tried it two times: twice I got a message that the post did not go
through, to try it again later. Tried it again later last night and decided
not to check that box. The post was successful, but i was really surprised
that it had posted twice. I really don't know why.

Is there any way that the redundant postings can be deleted?

 

[Guest]

John,

I did get your answer, most illuminating in fact. I really appreciate the
time and goodwill you put into it. I know I'll get back to you for further
clarification as I try and implement it. As I answered to Rick B, I got three
error messages yesterday about failure of my postings to go through. to the
point that I started typing ther post again in Word so I could just copy and
paste it. I sent it home and pasted it from there, because I was tired of
losing it every single time. So you can understand my surprise when I saw
that there were 2 of them last night. I go back now and i see 4 of them. I'm
so embarrassed it's not even funny. I hope the community doesn't think I'm
trying to hog the space here to myself. This @#&*%^ web-based community
"thing" was simply not working properly. Again, thank you so much.

Rene,

 

[John Vinson]

This @#&*%^ web-based community
"thing" was simply not working properly.

That's the problem. You're not at fault - it's Microsoft's flawed
website implementation. You'll see that very few of the MVP's and
other volunteers here use it; I use Agent instead, and many use
Outlook Express as a newsreader. Just use msnews.microsoft.com as the
news server, and avoid the annoyance altogether!


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

John,

If I may... The .PRT report file that is the basis for the tables data has
an account number - that is always unique - that includes the building number
and a building "unit", which is different from the apartment numbers we give
as addresses. They're in this format "308-002", "308-004", then "310-002",
"310-04","310-260" etc. These numbers are actually painted on the doors.
I'll take the apartment "unit" out of it and enter each unique value as the
BuildingNo for the Buildings table. Should I also add the account number from
this report as an "apartment unit" additional field in the Apartments table,
as well as in the Rentals table but now as a real AccountNo field and use
this field instead of one of the three you originally said should be a
3-field joint PK for the Rentals table? Long-winded questions, I know. I hope
they're clear. Thank you so much.