Hi John

My personal preference, and which I believe to be the 'standard' is to use 'real' names for fields, like Name, Address and so on. For memory variables I always use different prefixes.

For the prefixes I try to follow the standards which I first read about in Codebook. No standard is the best standard, but it is a logical and easy to remember standard.

Some examples of my 'standards':

lcName: l for local, and c for character.
gnVat: g for global, n for numeric.

But, as mentioned above, no prefixes for field names.

>I am creating a new database should I prefix the fields with their type e.g.
>
>cName
>cAddress
>dDob
>etc
>
>or just use the field name e.g.
>
>Name
>Address
>Dob
>etc
>
>Any opinions welcome.
>
>
>Thanks.
>
>John