|
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.
Navigation:
[Reply to this message]
|