Invalid definition problem

[Harold Lethcroft]

Hi

I am aware of a post (named: Invalid Field Definition - Unable to set up cascade update but I have done what the moderator advised and have not been able to fix a very similar problem.

I have planned a database and must adhere to the plan or change it and basically I initially said that I would like to enforce referential integrity to synchronise my tables and I would also like to cascade update and delete to save input time because changes will be automated between table (where fields are connected.).

I have attached a plan I did if that makes the purpose of my database clearer.

I have attached my database and have established the relationships* without referential integrity enforced I would like between my tables but don't know how to make them one-to-many relationships nor can I enable cascade update or cascade delete or enforce referential integrity.

I am new to databases (and to this forum) and have been promised by my line manager that I won't have to specialise, with this in mind please try to keep your advice clear and simplistic.

I look forward to hearing from you.

Dominic

* actually I don't think I have created the relationships but they are supposed to be between Vehicle ID and Hire Number, and Customer ID and Hire Number.

 

[GinaWhipp]

Well, the first problem was your documentation did not match your tables. You can't *relate* tables if you do not put the Foreign Key in the tabgle you plan to relate to.

As for Cascade Delete, I never use it, just make the records Inactive/Active or InService or Not. You may need that record for historical or any other number of reasons. I have adjusted your tables, set up your relationships for Cascade Update only and re-attached.

I'm also going to suggest a little reading...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page...
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials

UtterAccess Newcomer's Reading List
http://www.utteraccess.com/forum/Newcomer-s-Reading-List-t1998783.html

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
http://www.databaseanswers.org/data_models/

Naming Conventions…
http://www.access-diva.com/d1.html

Other helpful tips…

Setting up a Model Database
http://www.access-diva.com/d11.html

My Database Standards...
http://regina-whipp.com/blog/?p=102