Invalid Field Definition

[RebeccaH902]

Hi
I am creating a database for my school and I can't create a relationship between two tables. There are only two tables and I need them to be one-to-many however it says there is an 'invalid field definition'.
I have attached the database, if anyone could help me out that'd be great
-Becca

 

[James Dudden]

It's because you're trying to link an Autonumber to another Autonumber and this is not allowed. Change the child table from an Autonumber to a Number (long Integer) and then the link will work.

 

[RebeccaH902]

Thank you so much! Can't believe I forgot that :banghead: