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