Join Type

[Andyjones]

Hi I am having a go at creating a relational database all the joins are there but when i create the 1st form it and when I try to enter the details it keeps saying not in record set, could someone have a look for me correct my mistake and explain how i got it wrong.

Thanks

[orange]

I think you should review some concepts to ensure you have the proper tables and relationships.
If you are interested here are free video tutorials that you may find helpful.
http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

You can go back and watch these as often as you want.