Let's rewrite your X relationship so that we have distinct occurrence names:
PersonnelLocations::anyfield X AllPersonnelLocations::anyfield
Now we'll pull all those usernames into a list called cAllUserNames: List ( AllPersonnelLocations::UserName )
Add this relationship:
PersonnelLocations::cAllUsernames ≠ Hires::UserName
Note: this method fails the first time you get two employees with the same name.
Thanks! This worked, but only when List ( AllPersonnelLocations::UserName ) is evaluated from the context of PersonnelLocations. When List was called on the Username field from the same context as the field was specified from it didn't work. I don't understand why this is, but it's working.
It takes ten seconds or so to process all the records the first time, but it doesn't do it again even though the calculation is unstored. What would trigger a recalc?
Usernames are always unique, so I don't have to worry about dupes.