Re: [libreoffice-users] Re: Database help please

Thank you to everyone who replied to my query, A01, A02 etc works, I am
very thankful for that. Now the problem to prevent duplication, I have
tried several ways but obviously what I am doing is incorrect as it doesn't
work.
Could someone please do a very small database to show how this problem can
be overcome.

Many thanks in anticipation.
John


On 3 March 2016 at 11:54, Alexander Thurgood <alex.thurgood@gmail.com>
wrote:

> Le 02/03/2016 20:07, John Montgomery a écrit :
>
> Hi,
>
>
> > 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.
>
> As others have mentioned, you could try using a double, triple,
> quadruple, etc, digit numbering sequence from the start. If your
> cemetery has 4000 graves in row A, then enter A0001, A0002, etc.
>
> Alternatively, create a separate table for your row/number
> identification, with a unique ID value for each pair, concatenate the
> result in your form, but sort them via the unique ID value.
>
> Alex
>
>
>
> --
> 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

-- 
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