Database help please

users
#1

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

#2

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:

#3

Enter A1 to A9 as A01 - A09

Similarly with B01 - B09, etc

Tony Bray
tonybsa@mac.me
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,
Mac OS X 10.11.2
LibreOffice 4.4.5
Scribus 1.4
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4

#4

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

#5

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

#6

Hello John. I am thinking that you are seeing duplicate grave numbers? If
this is correct then I suggest creating an index for the grave number
column and selecting the option that the index be unique.

That constraint, unique, will prevent duplicate entries. It will also
prevent successfully creating and saving the index as long as there are
duplicates in the grave number column.

So first make sure there are no duplicate grave numbers in your table (that
includes grave numbers that have not been entered, e.g. blanks). Then
create the grave number index being certain to select the unique property
for the index. Save the change and it will no longer be possible to save a
record with duplicate grave numbers.