Marty, I don't think you are missing out on anything, I haven't a clue why the question is being asked nor why it might be useful to know the answer. And I *do* use the RINs, all the time, for identification. Furthermore I do not fill unused RINs so I have a few hundred gaps. Do I miss them? No!
The RIN is a unique identifier for each individual in the database, but does it matter what number it is? Not in the slightest. Ron Ferguson _____________________________________________________ *New* Tutorial: Add Location Pins to Google Earth http://www.fergys.co.uk Includes the family tree for Alan J Grimshaw And the Fergusons of N.W. England ____________________________________________________ ----- Original Message ----- From: Martin Hahn To: [email protected] Sent: 21 May 2010 05:11 Subject: Re: [LegacyUG] Missing RINs Why would it matter? I don't use RIN for anything. What am I missing out on? -- Marty On Wed, May 19, 2010 at 9:16 AM, Dennis M. Kowallek <[email protected]> wrote: On Wed, 19 May 2010 00:27:00 -0500, Robert Carneal USA <[email protected]> wrote: >Does anyone know of a way to get Legacy to generate a report listing >the RINs that are empty? Say I have: >... >4 >5 >6 >8 >9 >10 >... > >Then the report tells me "7" is not used? Robert (and others): If you have "Reuse abandoned RINs" turned on, then tblXI contains a list of the missing RINs. You can run the following query in Access, LTools, OOBase, etc.: SELECT tblXI.DeletedID FROM tblXI ORDER BY tblXI.DeletedID If you do not have "Reuse abandoned RINs" turned on, you can turn it on temporarily. This will cause tblXI to be rebuilt. Then you can run the above SELECT query. When you are done you can turn off "Reuse abandoned RINs". -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
