I have a situation whereby I want a number field within a table to be sequential but only when a number is required for that record. When the number field is populated I want it displayed with leading zeros - such as 000111, 000112, 000113 etc. on a given layout. As an auto-enter serial number I can pad the number as required on the Manage database screen and it seems to displays as required. However I cannot seem to achieve the same on a number field through the Inspector Data formatting screen. I cannot see a way to specify a new format.
Would appreciate if anyone can advise whether this is possible. If it is not then I can possibly relate it to another table with the auto-enter serial number as and when required. You might tell me I should do this anyway, but thought I'd ask.
Thank for your help as always.
Message was edited by: Dave Fields Header caption set to lowercase as requested.