Posted by Frankly on 05/04/06 19:01

Even tho my wife has begged me to step back a few days. I find I cant I
feel like the Blues Brothers and I am on a mission from God. J

I love a challenge and the worst part of this is not knowing if this is
something I can teach myself.

Well my wife is right I have become obsessed with this. It is very
important to me.

Yesterday I couldn't stay away and played around with the tables a bit.



The way I have it now.



The Managements table has a 1 to many relations with the buildings table
using ManagementID. It is the primary key in the Managements table and
Foreign key in the buildings table.



The buildings table has a 1 to many relation with the apartments table.
Using BuildingID

As primary in the buildings table.



I think this is right because when I look at the tables the Management table
has the buildings table as a sub table; the buildings table has the
apartments table as the sub table.



If this is right. then perhaps the buildings table should have a 1 to many
with the zip code table and also with the area table. or should the area and
zip code have a relation or should they be in 1 table. My wife is right I
am spent; I know I should step back a few days but I always feel like I am
one step away and that I should keep going.

I am happy with the new relations I have created and I hope it is right.

Could someone tell me about how to post the code?

Thank you again.

[Back to original message]