Posted by Frankly on 10/14/19 11:48

"J.O. Aho" <user@example.net> wrote in message
news:4but6tF13ulrrU1@individual.net...
>
> You can make relations in the following way
>
> Management table:
> ManagementID
> Contact
> Phone
> Address
> Notes
>
> Buildings table:
> BuildingID
> Building
> Street
> CrossStreetA
> CrossStreetB
> CommonOutdoorSpace
> BuildingContact
> ContactPhone
> BuildingNote
> Area
> ZipCode
>
> RelationManagementBuilding table:
> ManagementID
> BuildingID
>
> It's IMHO easier to join with this method and you can have multiple
> relations. You can have one row in Management table to be linked to more
> than one Building, which in it's case can be linked to many Apartments.
> Your setup limits a one to one relation all the time.
> One way is to create a ZipTable were you have



I know I am not the fasted index in a database but are you using the
relationManagementBuilding table as a linking table to create a Many to Many
relation?
I have been using Access while i wait for my host to upgrade MySQL to the
current version.
I am begining to wonder if i should or if i can do that upgrade myself.



>
> ZipTable:
> ZipCode
> Area
>
> you can then in theory drop the area column in the buildings table and use
> JOIN http://dev.mysql.com/doc/refman/5.0/en/join.html to put together the
> Building table with the ZipTable and you would get the correct area (as
> long as the right zip code has been entered).


I tried this in Access with out any luck. i was able to create a combo box
in a form with fields for Area and Zipcode.. however when i selected the
Area it wouldnt automatically bring the zip code. in other forms i was able
to include fields from other talbes that would get filled according to a
selection i made in a combo box.


>
> But I think you will always want to see the which area the building is in,
> then you still want to make that Area column, as it will speed up searches
> (join takes time, more the more rows you have inb the both tables).
>
>
> > 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.
>
> I do recognize myself there, been times when I spent up most of the night
> working on some project. But keep in mind, spend time with your wife or in
> the worst case you may not have one and then there wouldn't be any point
> with this project.
>
>
>
> //Aho

I am not as bad any more. I do get addicted mostly because I always feel
like I am just seconds away from learning something new. I feel more
confident with Access but I dont feel right not using something I feel is
better.
If I am able to do the MySQL install on my own I wonder how long it would
take.
Because of all the different flavors of SQL like MySQL and how directions
are version specific i think i would rather just learn SQL. i tried to
bypass PHPmyAdmin a few times by going straight to the SQL window with
tutorials nothing seemed to work. I wasnt sure how my current version
would differ from the latest version so i didnt get into it like i should
have.

[Back to original message]