Possible Linking Problem/ if then else Formula trouble

[DOMAL]

My current formula is thus:

if {SLSCUMTRX.TRANS_TYPE} = ["1"] then 'No Code' else if
{SLSCUMTRX.TRANS_TYPE} = ["4"] then {SLSINCLIN.PRODMF_CODE} else 'error'

But for some reason the 'trans_type' 1's get knocked off the report when I insert the field? I figured the above was sound?

I have tried linking the tables in a different way, it worked (still showing the '1s'), but everything got triplicated and worse, making me think that linking isnt the way around it.

I hope there is enough detail above.!

Help!!

 

[DOMAL]

Nevermind, I set the link as 'left outer' on the linking tables and thats sorted that problem, I've got another now!