Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I get a null when trying to use the function in the following way: FirstSortedValue (user_name, currentPerm).
while using 2 parameters from the same table, its working OK.
All the values of 'currentPerm' - the sort-weight are unique.
Can anyone suggest a way to solve it?
can you not use UserCode instead of User_Name as appears in both tables?
can you not use UserCode instead of User_Name as appears in both tables?
I could but i prefer to display the name.
Finaly I joined the 2 tables and the problem was solved. its not the best solution but its working.