Error Message when building table relations

[Mere1]

Hello - rather new to this so go slowly ! Whilst working on OOO 3.3 on Windows 7 I have a number of simple tables for a database, pupils, parents, schools etc. When I try and make a relationship between two tables I get the following error message:




SQL Status: S0021
Error code: -57

Column types do not match in statement [ALTER TABLE "Pupils" ADD FOREIGN KEY ("SChool ID") REFERENCES "Schools" ("School ID")]

I have made sure the field types are the same. I deleted the programme and reinstalled it. I tried it with other tables but I got the same error code. Could anyone help me ?
Many thanks in advance

[Sliderule]

I suspect the error is because the field name . . . as you the error message displayed "SChool ID" must match the table definition names, exactly as it is defined in your table . . . including . . . CASE ( UPPER / Mixed / lower ) .

For example, a field name of "SChool ID" is NOT the same as a field name of "School ID", nor, "school ID" . So, make sure the letters between the double quotes are entered EXACTLY as defined in your table definition, including CASE.

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.

[Mere1]

Thanks so much for replying. Sadly this occurs with all the tables, so if I do 'sport' or 'team' the same thing happens. But that's a really interesting point, I didn't know you had to have the same fields if making relations.

[Sliderule]