StewartR

Maybe I went about it the wrong way, looking for the circular reference. Here's what I did. I made a list of people with a report, four columns: Person - Person's ID - Father - Father's ID Using Excel I created a column that showed the Father's ID for the Father. (Using LOOKUP.) So now I have Person - Person's ID - Father - Father's ID - Father's Father's ID Then I made a column where I subtracted the Father's Father ID from the Person ID. Person - Person's ID - Father - Father's ID - Father's Father's ID - Check # A circular relationship would have netted me a 0 in the Check #. No zeros. I then extended it one more time, no zeros. And a fourth time, no zeros. And I did the same for the mother's. No zeros. So I'm wondering, is there perhaps a simple solution to finding this possible problem of a circular relationship?

Thanks John. It will give me something to analyze and see if I can find a smoking gun in the database.

I'd like to know if there is a practical limit to filtering on "Is an Ancestor of...". I was recently using TMG 6.12. And needed to update my accenting based on some major changes and additions. The report using that filter failed. TMG appears to lock up. Several hours of disk grinding, to only quiet down, and never return. The database contains 27,000 or so people. (Not all my ancestors, but the lineage is extensive.) So I upgraded to TMG 7.02 thinking new programming would address such possible memory glitches. It does not. TMG again locks up on that report/filter. I tried using the Related By "book of reports" that I found online (probably Terry's). But it locks at the report that looks to mark my ancestors. This feature, the accenting of Ancestors, and setting all the others, (using individual reports to set and reset flags), has worked in the past. And I absolutely think marking the "direct line" in every view, through children and everything, is something I can't do without. Is there a limit in TMG on how many "ancestors" can be found before it quits?