I have inherited a database created by someone else. It has a reference number comprising of letters and sequential numbers.
When the user creates a new document, they are prompted on queryopen to select the document type (and therefore the letters to be used to prefix the number), this is then used to look up the next available number for that prefix (on a separate document), which is used for the reference number. The number returned is then incremented by one and written back to the number document.
Obviously there are problems applying the number at queryopen (ie even if the document is not saved, the number still increments), however the user is experiencing erratic numbering far beyond the extent you would expect with creating and not saving documents. Numbers are working sequentially, then suddenly jumping anything from 2 up to 60! Does anyone have any ideas, because I've tried everything I can think of.