I have a custom record with a list of ZIP Code (primary key) and other fields. We've added a custom body field on transactions to hold the record id We want to take the {shipzip} form the transaction and match it against the primary key on the record. I have workflow to update when record is created/saved but it doesnt work: Invalid custbody_zipref_zipcode reference key 'xxxxx' for custbody_zipref 'xxxxx' Any ideas what I've done wrong here?

Try using custbody_zipref_zipcode.id in your workflow action

@Javier Magana that doesnt work for me. The {shipzip} is text field on the transaction and = '10103', for example. The trans also has a custom field {custbody_zipref_zipcode} which is a List/Record type, liked to the ZIPMaster custom record I need the value of {shipzip} to look at the custom record, and load the relevant ID in the {custbody_zipref_zipcode} field. ZipCode is the identifier field (Name) on the custom record. Not sure if this explanation is helpful, or even makes sense!!!