What would cause related( to work for most, but not all fields in a database? I can get it to work with text, dates and numeric fields overall, but a few text fields absolutely refuse to work. I’ve double-checked names and spelling, and I’ve used catcherror(“X”,related({ProvinceFrom},“Workers”)) which comes up blank. There are just a handful of fields that routinely fail. Why? I can’t find anything about them that is different from fields that work, and yes, they have content.
