id with "0" before
i'm using fmp 11.
I want use an id made by 4 numbers.
some 0 and the number.
... and, after 9999 ?
the end of the world
Ids do not have to have any meanings for anyone and they have to be free to grow !
in this case the id is not a primary key, but is a part of that
"but is a part of that"
Could you expand a bit ?
the priumary key is made by : a letter, an input number, the year and a serial number
You would be much much better off using just a straight serial number as your primary key and keep it hidden from users. Use this key you are proposing here, if you need it, as a "label" field for users to identify records in searchs, sorts, etc.
Define the field as a text field, not a number field.
Retrieving data ...