Hey bobs thanks for your help previous...seriously without your graphically instructions... i was going insane for last 4 hours....
one question..... do you think my project is done? cus query is optional...... does it mention anywere where i ahve to create forms?
Oh... so each time i conect something i have to create that ID also?
i thought it would add it automatically since i am adding it while doing the relationship....
thanks for the graphics.....
does the order matter of the field... since i am gonna add new field such as "HID" which will be at...
i am confuse ...but
isn't when i create a table it input a field called "ID" automatically ..that is the primary key field? then i just renamed it as CustomerID... and so on for the other table...
so then i try to link CustomerID to ReservationID?
what am i missing
any way to fix the data to...
but what i possibly can do wrong... acess is not letting me do the relashionship..... its perfectly fine when its only
Enforce Referential Integrity is enabled, Cascade Delete Enabled
yeah that i know ..the slides pdf contain clear version of relasionship image...
my problem is i am doing something wrong.. because i am unable to apply Cascade Update enable
it give me the following error..
"Invalid field definition 'id' in definition of index or relationship." for all...
well i guess yes i am joining one primey key to another one isn't?
isn't like chose the CATID to ISLAND ID??? which is both primary key and both autonumber? isn't that what i am suposed to do
the relationship works fine when
its
Enforce Referential Integrity is enabled, Cascade Delete Enabled
when
Cascade Update is also enabled then i get
"Invalid field definition 'Itemnumberid' in definition of index or relationship." for all the table
All rite i get it..i guess i became the joke of the week..hehe..u guys must having a blast laughing at me...well yea i should do my work on my own then get help..
however i managed to do the tables but now i am stuck....only have few hours left..
Any idea why i can't do the relationship to...
All rite i get it..i guess i became the joke of the week..hehe..u guys must having a blast laughing at me...well yea i should do my work on my own then get help..
however i managed to do the tables but now i am stuck....only have few hours left..
Any idea why i can't do the relationship to...
Listen my dear ... there is no point for you to remind me what a student should do.... cus we all know it....
second of all its a online course there is no teaching going on... i know what i am saying....
bob with all the respect ... what you trying to say? seriously if u can't help why u critisizing..... the fact you are familiar with acess so thats why you talking with that point of view... anything we know its easy... anyways man its will be nice that u can help other then bitching at...
its not that.. teacher expect to know it by ourself without no material whatsoever... thats just not right u know..( so if i am really bigener to acess is not easy at all)
its creation of simple reservation. both files explain what should be included...bluprint is also included
http://rapidshare.com/files/76226655/Comm499i_MiniCases_Access_notes.pdf.html
http://rapidshare.com/files/76226689/Comm499i_MiniCases_Access_slides.pdf.html
15 to 20 mins if u know ur...