Hi,
I am having a little trouble with the auto update function. What I would
like to do is store the name of the user who last modified the data record in
the data records table. The name is drawn from the names table which is
linked to the currentuser() of the PC. I am aware that it is not good
database design to store the name directly into the underlying data table,
but due to exporting/importing my boss wants it done this way (!).
What I have done so far is have a combo box that draws the name from the
names table where the userID=fosUserName() [kishor devshi's code *thanks*].
when the record is updated I would like column 1 of the combo to store in the
data records table. Am I on the right track?? Many thanks for your valuable
time.
|
Similar Threads
