I'm mystified. I've got a table that includes four fields (among the many other fields) to keep track of who created the record and when:
createdate = Auto Enter Creation Date
createby = Auto Enter Creation (AccountName)
modifydate = Auto Enter Modify Date
modifyby Auto Enter Modify (Account Name)
On the data entry screen, I've created four merge fields at the bottom of the screen,
Created on: <<createdate>> by: <<createby> Modified on: <<modifydate>> by:<<modifyby>>
I've created two users. jcheney and mkapoodle, both with full rights.
Now, when a log in as mkapoodle no changes seem to be evident.....the creator and modifier are always 'Admin'
Now, this is a split database, (two FMP12 files...) and I defined the users in the front end, rather than the back end, thinking that the once the front end validates the user, it can then use the default Admin account to log into the data.
But, I guess the larger issue is, what is the best way to implment this?
Note that for the moment this is not hosted on FM server.