ms-access: Why isn't this relationship not working?

just started today understanding relations between ms access databases. Can a开发者_JS百科nyone figure out why this isnt working?

I can explain a lot in my way, but I think that the pictures says more then 1000 words

---

When you have a relationship set up, you get the little plus sign in your datasheet (third picture) and when you click the sign, you see all records with a matching relationship field (column). If there are no matching records, you can add them, which is indicated by the asterisk (*)

The plus sign will only show related records. If you have used relational integrity, you can only add records to the 'many' table that have an identical foreign key (matching field) to the 'one' table. It is not a good idea to work with tables, you should use forms. If you set up a form based on the 'one' table and add a subform based on the 'many' table, the foreign key will be filled in automatically (the wizard will set the link child and master fields for you).