PSA / Bug? : LOOKUPVALUE with relationships

User Table:  

userid

firstname

lastname

name (calc column - firstname & " " & lastname)

DataTable:

...

...

created_by_id

assigned_to_id

...

Was playing around with trying to correlate a userid field with both a created_by and assigned_to field - so I made a relationship between the assigned_to and userid fields, and it wasn't pulling in using RELATED - because I wanted the name field, not the userid field.  So, I ended up using LOOKUPVALUE to pull in the name field, using the userid as the lookup field and assigned_to as the lookup value.  It worked perfectly!

So I went to duplicate it for the created_by field, and it wasn't working right.  It would pull in some values, but not all, even adjacent records, with the same created_by id - some would work, some wouldn't.  It ended up being the relationship that I had made in the beginning, and forgot about - because once I deleted that, it worked great!

So, PSA - if LOOKUPVALUE isn't working as expected, try removing the relationship!