>Charlie,
>
>Fantastic. It works. Just had to do a little tweaking and I got it just the way I want it.
>
>After three days of chasing this around, I very much appreciate you pointing me in the right direction.
>Thanks!!!!!
>
>Fred
Fred,
Another option would have been to open the master table again under a new alias in the child form and set the relation as you wanted it.
Master -> Child -> Master1
Because you were using the default datasession setting for the forms, no new datasession was created and both forms lived in the same session. As such, when you opened the child form, it found that both tables already existed and it didn't have to open them. But it did have to set a new relation. Because relations are added Additive, it created your cyclic relation. And as you found using separate datasessions per form corrected this problem.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao