Re: If formula on a field in a relation table not working.

Yep, the IsNull is documented not to work on text fields,. Not intuitive, I know and many before you have fallen in that same pothole.  So you need to compare it to empty quotes.  I like to Trim it just in case it has some invisible spaces in the data

If (Trim([Target Region])="","Non-Target","Target")