AnsweredAssumed Answered

Timestamping and locking fields.

Question asked by julieFrith on Jan 31, 2011
Latest reply on Jan 31, 2011 by philmodjunk

Title

Timestamping and locking fields.

Post

Hi everyone. 

as always, any help would be appreciated. Thanks in advance, Jules. Heres my problem. 

I want to create a customer record database. Quite simple name, contact details and a notes section. 

I'd like the notes section to be constantly updated as and when we talk to the customer etc by different members of staff. 

I've set the database up with different account users and set my 'notes' field to be a repeating field but how can i automatically enter a timestamp into each repition and the account user details in? i.e so i know who wrote what and when. it would be even better if this couldn't be edited once entered?

Is there a better way of doing this other than repititions? 

Jules

Outcomes