>Its like this...
>One main table called aledger. This holds some data, and two constitid numbers. (constit short for constituent) One number for a site, one number for a payee. Both of these are out of constit. The form this is all in reference to must show the data in aledger (start dates, etc), and the address/fei info for the two constituents. The only way I could figure it out to have all the information show was to have the constit table 'use'd twice in the DE with two different aliases. As one pages through the records in aledger, the two constit aliases page along to their links (which are standard integers). The problem arises that when certain things are done (a seek command in a search routine) the two links from aledger to the constit aliases are lost, the address info is not displayed, and all hell breaks loose. Sorry I didn't explain it better earlier. 1) Is this the right way to go about it? 2) Why is is losing the links? 3) How do I keep such from happening?
>
>Thanks for your help in this.

Brian

I dunno! I never set a relationship to a copy of the same table before. I used other methods. If I need to look up other info I would just do a SEEK() especially since you have unique fields. A very simple way is to eliminate the relationship & do a SEEK() or a SELECT to ARRAY or something. Maybe someone else has done what you are doing before but I have not.

Tom