Posted by Frankly on 05/03/06 19:12

"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).
>
>
> //Aho

wow that is great thank you.



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

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





Management table



ManagementID Auto #- Primary key for relation to foreign key in
BuildingsTable

BuildingID - # - Foreign Key for relation to Buildings Table

Contact - text

Phone - text

Address - text

Notes - memo



Buildings Table



BuildingID - Auto # - P-Key

ManagementID - # - FK

ApartmentID - # - FK for relation to Apartments Table

Building# - text

Street - Text

CrossStreetA - text

CrossStreetB - Text

CommonOutdoorSpace - yes/No

BuildingContact - text

ContactPhone - text

BuildingNote - Memo

Area - text or combo

ZipCode - text or combo - not sure if i should use a combo box for Area and
ZipCode or just text boxes.





Apartments Table



ApartmentID - Auto# - PK - relation to Buildings Table

BuildingID - FK - related to buildings Table

Apartment - Text

Rent - Currency

MoveInDate - Date

StillAvailable - Yes/No

Pets - combo field for these choices - yes, No, cats only, Under 12lbs

TenantContact - Text

TenantPhone - text

Elevator - yes/no

Laundry - Yes/No

PrivateOutdoorSpace - Yes/No

DoorMan - Yes/No

ApartmentComments1 - Memo

ApartmentComments2 - Memo



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.

My main concern is to have a good foundation that I can start using and as I
learn more apply what I learn.

I have looking into converting Inventory Control database, changing the
tables around a bit.

but feel being this is the first step in many. I must learn this if I am
going to move on to SQL, PHP and or ColdFusion, learn more about HTML. I
know it doesn't look like I am trying as hard as I am but for the past 2
months. I have learned allot about what I will need to learn to create a
dynamic web site for my wife. The only feed back I have ever gotten was from
these groups. Thank you

[Back to original message]