It's def not the site connection, all is good there.
Interesting though, This site was duplicated from another site with fabrik on it, and also this particular list (where the user field is) was an import from a csv (this data was originally a access db). I did successfully convert the userid field in that import field to a legitimate J! user field and connected the users to the corresponding J! user.
I'm wondering now if this might be causing the issue, although I converted everything perfectly. nothing wrong with that list. It displays the name just fine when looking at that list itself. It is when I am using a databasejoin field (to that list) in another form that the issue arrives.
If this was a copy, is it possible something could be wrong with the Fabrik metadata tables?
I think I am going to subscribe to Pro Support. I am way behind on this project and I normally don't have much issue with building with Fabrik, but this particular app has been giving me fits. You guys have been very helpful and I appreciate it, I have a feeling I may have more questions.
Thanks