Global Calculation Field as Relationship reference issue

[Don_Macaroni]

I have a global calculation field which acts as a reference for a relationship... But it doesn't work.

If I use a global number field and enter the same data manually as is calculated in the global calculation field, the relationship works just fine. Weird or am I doing something wrong?

As I am making a touch screen solution, a four digit sequence ( eg. 2395 ) is made up out of 4 global fields ( eg. field_one & field_two & field_three & field_four ). Each global field can be manipulated by a plus and a minus icon, going up and down from 0 to 9. Very simple, works fast and flawless. Except for the generated number not making a match with related table.

Anybody?

[comment]

Most likely, your calculation's result includes some extra characters (e.g. a space) that prevent a match.

[Don_Macaroni]

I just found a typo... very stupid. Been working on this complex database for 5 hours straight and I guess I need to rest a little.

Thanks.