Linking 2 tables does not link correctly on all fields

[BobKoenen]

Hi,

I have a Dim table and a Fact table. The Dim table has no duplicates or empty rows and I have linked the two tables on a [one to many] relationship. So far so good. 

Unfortunatly the linking has not worked for every key field somehow. I get the following result when visualizing this in a table:

Dim table Key	Fact table Key
	3030
	4045
5212	5212
6246	6246
7050	7050

The DIm table does contain the values 3030 and 4045 but somehow the connection is not found. 

I have done the following things:

- Both fields are tekst
- I have cleaned and trimmed the fields in the query editor

But still some keys are not found. Do you have any Ideas what could cause this issue and how to fix it?

[BobKoenen · Accepted solution]

never mind...stupid query editor formatted it as a number in the beginning and thus got rid of the 0 at the beginning