Hi I am trying to pull a value from Dynamic Registration into Dynamic User Directory. I was succussful in pulling the value over but it's not the display I want.
For example, the combo box on Dyn Reg is the following:
SELECT Users.DisplayName as QuestionOption, Users.UserID as QuestionOptionValue, UserRoles.RoleID, Roles.RoleID, Roles.PortalID FROM Users, UserRoles, Roles
WHERE Users.UserID = UserRoles.UserID AND UserRoles.RoleID = Roles.RoleID AND UserRoles.RoleID = 2 AND Roles.PortalID = 0
ORDER BY Users.LastName
I guess my problems derives from this. The Dyn Reg works exactly like I want it to.. however, when I bring the value over to Dyn User Directory I get the UserID value instead of the display name.
i.e. - I get the value 10 instead of Display Name.
Any suggestions? Thanks.