hi Peter,
>> It seems a bit overkill to have to designate these fields in three different ways:
fixed field name (e.g. 'TimeStamp')
external name (e.g.'ts')
user option (property 'timestamp' value '1')
>> Are they really all needed?
no, they are "in order". Having the user option allows the fieldname and external field name to be changed (although this is NOT something I'd recommend) - the external field name being short can be useful in places where the work timestamp is already used.
Setting the first 2 is a good idea, primarily because that's the way my apps are setup, and so the way that is most likely to work "clean".
Your question suggests though that you don't know that fields in the dict can be cut-&-pasted. the key is to set it up just once, correctly, in one table, and then just copy those fields to the other tables. That's pretty fast.
Alas you can't cut&paste keys, so that's a manual process to add them - and is slow.
cheers
Bruce