Well, until someone can show me how to do this, I have solved it with another hack, involving some duplication of data.
I’m changing the reference field to a text field which has a copy of the unique field I want to refer to in the other table. I can just copy the text over when I create the record that needs the “reference”.