Database error code -177

[Uiop541]

Working on an online school project with database and I need to finish this class ASAP and I was wondering if any of you could help me with this error message I'm getting?

[FJCC]

What are the column types of Organizations.OrganizationName and VolunteerHours.OrganizationName? They should be the same type. You can check the type by going to the table pane, right clicking on the table icon and selecting Edit.

[Uiop541]

They appear to be the same?

[eremmel]

There are more aspects that define a type than only the keyword 'VARCHAR', The type of a text field is 'VARCHAR(N)' with N the max expected length in characters. Now rethink your relation definition....
In theory you can only make a relation between from fields f1 to f2 that have the types VARCHAR(n1) and VARCHAR(n2) when n1 < n2, but I will not be surprised that the constrain is even more restricted to: n1 == n2.

[UnklDonald418]

I downloaded your “Community Service.obd” in your post
In your "Organizations" table "OrganizationName" is type [VARCHAR IGNORE CASE]
In your "Volunteer Hours" table the foreign key "OrganizationName" is type [VARCHAR]. While similar they are still different types.
By the way even after changing them to matching types you may need to re-enter your data in that column of the "Volunteer Hours" table before it will work.