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