Timestamping and locking fields.
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?