Automatically update a field with a looked up value
I have a little problem with a field I want to update automatically with a value.
I'm using SQL server as a DB an I have a table with user information such as uid, full name, location ,....
When a record is created I need update a field with the full name of the user.
With Get(AccountName) I can get the uid of the user but how do I retrieve the user's full name and enter that value in my field?
It should also work in IWP.
Thanks in advance.