Posted by J.O. Aho on 05/04/06 20:50

Frankly wrote:
> "J.O. Aho" <user@example.net> wrote in message
> news:4bqnujF12n3psU2@individual.net...
>> Frankly wrote:
>>
>>> I am thinking about getting another tuturial.
>>> is there a way I could post the code here? could i post the tables and
>>> feilds to get a little feed back?
>> cut'n'paste the code here and describe how your tables look like (column
>> names and datatype).

> wow that is great thank you.

Thats how things can be done here and it has worked well before.
sorry that I missed your posts, been busy on my end.


> As far as the code goes, I am thinking you mean (row Source type and Row
> Source)

Raw code, your php script.


> once I know I have the table structure right, I will know if problems are
> in what I am trying to.

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.

> I would also like to be able to add a Area Table and ZipCode Table or
> separate tables.
> Not yet but once I start to look into queries I would like to
> put the Area to a building that it also brings the zipcode.

One way is to create a ZipTable were you have

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).

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

[Back to original message]