showing the last user who has saved 1

[Guest_imported]

How could i put the name somewhere in my database to show the last person`s login name who had saved..

-Rob

 

[suesloan]

You can mark records but not the Approach file. If you want to know who last modified a record:
1) define a variable type field with data type of text and put it on a form, I'll call it VarID.
2) write a global script that puts the user name from Team Security login into your variable field. You can run it from a macro named OPEN that will run when each user logs in:
OPEN
. VIEW switch to the form with VarID on it
. RUN GetUserID

Sub GetUserID
. CurrentView.Body.VarID.Text = CurrentDocument.User
End Sub

3) add a text field to your database with a modification formula set to just the variable field name VarID

Now each time a record is changed, the user id will be stored in it. You may also want to add a moddate and modtime field with modification date and time in it too!

Sue Sloan

http://www.xpertss.com