Acess Problem with relationship

[romeo2010]

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 none of the table...
it gives me error

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
"Invalid field definition 'Itemnumberid' in definition of index or relationship." for all the table



http://rapidshare.com/files/76611241/reservation.mdb.html


How do i implant the followings ... i just don't get it how to ue it in acess

BUSINESS RULES
• Structural Constraints
• Derived Facts:
• Hotel total = hotel rate/night * # of nights reserved.
• Vehicle total = rental rate/day * # of days rented.
• Reservation total = hotel total + vehicle total + cruise rate +
flight rate
• Operational Constraints
• A person may make a reservation only if he/she is over 18.
• A person may make a car reservation only if he/she is over 21 and
holds a valid driver’s license.
• A person making a flight reservation to certain Island, can only pick up
a car, or book a hotel, etc, to that certain Island

 

[romeo2010]

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?

 

[boblarson]

I don't have time to answer all of those questions. Have you tried to work through these tutorials?

http://www.functionx.com/access/index.htm

They are REALLY GOOD and you might find it answers a lot of the questions you have. I know you don't have a lot of time and you should have probably started sooner, but that's the best I can do right now.

I will answer the fact that your relationships will provide some of the structural constraints.

And check out these for how to do the totals:
http://www.functionx.com/access/Lesson29.htm
http://www.functionx.com/access/Lesson30.htm