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:

 

[Pat Hartman]

There were three tables in the database, not two. Changing the ID of the child table to Long Integer will not solve the problem. The child table needs its own primary key which should be an autonumber but it then needs a long integer which will be the foreign key to the parent table. So, I'm presuming the foreign key will be something like NameID. I also see that you have Reason defined as a text field in that table. It should be long integer so you can join it to the reason table.