MS Access beginner needing help..

[neale1]

Hi all,

I am working on a project that requires me to develop a MS Access database for a motor accident company. I have created the tables and added foreign keys to relate them (not sure if they are correct). I have not defined any relationships in the relationships window. I then created a form from multiple tables so that I could start inserting data into the database. When I tried to insert data into the text boxes in the form I got the message in the tool bar at the bottom of the page, "Cannot add record(s); join key of table DriverDetails not in recordset".

Is the above problem caused by me not relating the tables correctly? I have no data in my tables yet because I was going to use the form to start inserting the data. Is this correct? I feel like I’m blindly struggling through this and am in need of some direction, can anyone help?

Many thanks

Neale

 

[492JQS]

This link may help:

http://www.access-programmers.co.uk/forums/showthread.php?t=67168

JQS

 

[KenHigg]

Can you zip this down and post it to this forum?

kh

 

[neale1]

Thanks for your replys 492JQS and KenHigg

Hi,

Thanks for your reply and the link 492JQS, i'll have a look through the notes.

KenHigg, i have attached the database. Would you mind having a look at my relationships diagram and let me know your thoughts and any improvements you feel i could make? I think i may have made some errors in relating the tables. If i can get this part right then i think i'll be able to start moving forward.

Im sorry for the late reply, i have been away since y'day and only able to log on this evening.

Thanks again..

Neale