Posted by Frankly on 09/30/43 11:47

"Martie" <martienospammin@newsguy.com> wrote in message
news:e3827302shs@drn.newsguy.com...
> On Tue, 02 May 2006 16:06:23 GMT, Frankly wrote...
>>
>>
>>"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
>>news:e3107q$snp$1@netlx020.civ.utwente.nl...
>>> rankly wrote:
>>>> I am using Access right now till i get a better understanding of
>>>> relational databases.
>>>> I know I will be working with PHP later on or coldfusion at this
>>>> point i am not sure.
>>>> I am no longer in a rush simply because i know - this can not be
>>>> rushed. Frank
>>>
>>> Better understanding from Access...
>>>
>>> I suppose loooking at the SQL view of your different queries might
>>> explain
>>> some thing to you...
>>> Learning proper SQL syntax will yield you a lot more.
>>>
>>> Grtz,
>>> --
>>> Rik Wasmus
>>
>>I am still having a lot of trouble creating forms for inputting data.
>>i tried to create tables for Areas and ZipCodes so that when i am
>>inputting
>>a new
>>building I can select from a combo box. I can get the zipcodes combo box
>>to
>>work but for the life
>>of me i was unable to get the Area combo box to work. when the combo box
>>for area showed the drop down menu - it was empty and very long. I
>>compared
>>it to the zipcode box and it should have worked.
>>I feel like pulling my hair out.
>>
>>
>
> Could be a simple syntax error but since there's no code to look at, our
> guess
> is as good as yours.

Now you know how i feel :).

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?

I would like that but what is most important is to have 3 tables that work
good together.

1- Management table with contact info and include a BuildingID field to
create a relationship
to the buildings table.

2 - the buildings table will have a relationship with the apartments table
via the BuildingID feild.

in my forms i have combo boxes to pick Management when adding a new
building.
and a combo box for picking a building when adding a new apartment.
they work great in the form except i forgot where i read to lock that info
once inputed.
and i also noticed that while the forms have the word choices from the drop
down menu
the table is holding the primary key infomation.

after i get that in a way that i know i wont end up having to delete all my
info because of bad design, i would like is to have the Area's and Zip
codes together so that when i attach an area to a building it brings the zip
codes with it ( each area has 2 or 3 zip codes ).
in the combo boxes i noticed that I almost changed.
the only way i can get the combo boxes in the fields to work show the data I
want is to open the form in design view - delete the fields and then re
enter a combo box via the tool box.

once the Database is complete i will need to be able to do searches via.
Area, Bedrooms, Rent, MoveIn Date, Pets, OutDoorSpace. just to name a few.
thank you again.

[Back to original message]