Access Error: Type Mismatch in expression

[G007]

I have a table (Main_Asset) with company asset info and another table (Service_Log) with asset service info. I`m trying to link them with a simple query (the link is between the field "Asset&quot but access keep give me the same error: Type Mismatch in expression. I had already link them on reletionship.

 

[fredk]

And you checked the data type for each field in the tables to make sure they are compatible?

Fred