A database you created or a template?
These letters are in browse or layout?
these are just some examples of what i have seen in example files i have studied, these are the names of the fields in the table, viewing these from the database manager...
Oh. Many developers and users advocate using random prefixes to designate global fields, db navigation fields, and other types of specialized fields. Some get carried away with cryptomanic labels.
I name fields like firstname, lastname, middleinitial - NameFirst, NameLast, and NameMiddle, but that's just me.
This way looking at fields in an alphabetical listing, all the name fields are together, all the address fields are together.
These are pretty standard naming convensions ...
c_ (means calculation)
_kf (means key, foreign)
__kp (means key, primary)
The purpose of the double underscore is so that the primary key sorts to the top and the single underscore (all possible foreign keys) sort right under primary and at the top.
Many developers also use:
zzc_ for calcs
zzg_ for globals etc ... so that all developer fields pop to the bottom.
Also, if a field MUST be indexed, the field name can be ended with _x. Standard fields are named as they should be, without the prefix or suffix. When viewing field names throughout FileMaker, we have not been provided a way to hover (as tooltip) and easily know the properties and purpose of the field so we must create our own standards.:smileyhappy:
Thanks a bunch, that really helps explain things much better.