I have a foreign field that passes through a table called moderators and then to the joomla user table. I have selected the name from the (joomla user table) when creating the view but when selecting it always comes up with the id number?

Any ideas whats wrong with this?

I have retried this with a very small component. The builder drags the name field into the brick. How ever when I view the Name field it says it is the (Joomla user email) field. Something is wrong with the builder when joining through tables.