TMG-L Archives

Archiver > TMG > 1999-08 > 0933654414


From: Lee Hoffman/KY <>
Subject: Re: TMG-L: Renumbering database
Date: Tue, 03 Aug 1999 00:26:54 -0400


Geoff Clout wrote:
>I have just finished merging two databases, one containing 223 names into
>one containing 17244 names. The resultant data base has the additional 223
>names starting at ID#17924 - a gap of 660 ID numbers.
>
>My question is, will the 17244 names retain their original numbers if I
>renumber all the numbers in the database? And secondly, why did the merge
>routine leave the gap?

Somewhere along the line you added enough persons to make the next higher
ID# 17924. Then you re-numbered, merged, or deleted those persons, but the
next available number remained. Before you renumber all the numbers in the
dataset, I suggest that you try a single renumber (you don't have to finish
it). Select the Tools=>Advanced Utilities=>Renumber People from the menu
to display the Renumber IDs window. Click on the To field and select
Search from the menu (or press F2). This will display all unused numbers
in the dataset showing the lowest first. You may continue by selecting a
number, pressing Enter, and then clicking the OK button -- or press ESC
twice to cancel out of the renumber process. If the lowest unused ID# is
less than 17924, then you may not want to do a renumber all procedure.

I suggest that you restore the dataset (you did do a backup before the
merge didn't you?) to what it was before the merge. Then ensure the next
available number is what you want.

I suspect you will find that the highest ID# is probably very close to (if
not) 17923. When you check out the Unused ID#s, I expect there will be
660 of them scattered throughout the dataset. If this is the case, the
only way to eliminate the unused numbers is to either do a complete
renumber (means you will have to "get used to" different numbers for
some/many persons), or you must renumber 660 persons one at a time.

Hope this helps -- at least I hope it helps explain the situation -

----------
Lee Hoffman/KY
E-mail:
My website: <http://www.users.mis.net/~lhoffman>;
--------------
A user of the best genealogy program, The Master Genealogist (TMG)

- ---------------------------------------------------------------------------
TMG-L The Internet Mailing List for The Master Genealogist
To unsubscribe: Send an e-mail to with 'UNSUBSCRIBE TMG-L'
or... if you get the digest version: 'UNSUBSCRIBE TMG-L-DIGEST'
- ---------------------------------------------------------------------------

This thread: