2 Replies Latest reply on Jan 8, 2009 6:37 AM by jefke

    Automatically update a field with a looked up value

    jefke

      Title

      Automatically update a field with a looked up value

      Your post

      Hi All,

      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.

      Jef