Data not linking

[JacoAucamp]

Can someone please assist me, the data in my tables do not link. I have to a fieldname that is in more than one table, but some of the data in the fieldname links to the different tables, but some won't. I assume it has something to do with the data structures, but I am not sure.

As seen in the picture the data looks the same, but it sits in different sides of the column which makes me believe it is has to do with the data structures.

[Or · Accepted solution]

One of these is numeric, and the other is text. You need to convert one or the other (or both, if you want to be safe) so they have the same type, using text() or num#().