Basically, you need to use the ID of the field tha...
# suitescript
e
Basically, you need to use the ID of the field that links the two records together, rather than using the record type of where you're trying to join