Re: [libreoffice-users] Database help please

I don't know if it works in your case, but perhaps using A01, A02 … A10 
will give the right order?
Kolbjørn

Den 02.03.2016 20:07, John Montgomery skreiv:
> Dear Sirs,
> I am trying to assemble a simple graveyard database but am having
> difficulty in getting the form to work as I want.
> I have tried to use parts of the "Search and Filter" database but end up
> confused. I have also read relevent parts of the Base manual.
> I have two forms, Graves and Burials, the Graves form covers ownership and
> registration of a grave and includes a photograph of any headstone which
> may be on site.
> The burials form is mainly for burial record keeping.
> The reason I have decided on two forms is that it allows me to see all the
> relavent data in one screen.
> Some specification criteria:-
> In both the "Graves" and "Burials" forms Plot No., Headstone and owner are
> to be common.
> Plot number is the primary key and therefore cannot be duplicated for
> obvious reasons.
> The graveyard is laid out in rows eg A to Z. Each grave in each row is
> given a number in sequence, eg A1, A2, A3 etc.
> My problem arises when I enter double numbers eg A11, A20 etc, these should
> follow in sequence but do not follow the sequence I want but A10 follows A1
> etc.
> How can I ensure correct sequencing.
>
> John


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted