>ZOrder alone should not affect the relationships. Are you altering the relationships in your grid somewhere?

I know it shouldn't, but without a doubt it is. It may not be affecting the releationship, but maybe just the display. Removing the ZOrder code makes the difference.

>
>Also, you may be better off using a pageframe to switch between the form and grid. If you have to use the button, I'd suggest putting the form controls in a container and toggle it's visible property along with the grid to switch between the two.

Thanks Ken, I'll give it a try.

>
>>Hi Ken,
>>Thanks for the response. It turned out to be some weird thing with Zorder(). I created a VCR control class that I had the following code in the init procedure. When I remove the code, it works O.K.
>>

>>For lnCount = 1 to ThisForm.ControlCount && Set form controls to Front
>>	ThisForm.Controls(lnCount).ZOrder(0)
>>EndFor
>>ThisForm.VCR1.ZOrder(1) && Set VCR controls to Back
>>

>>The reason I had this in the first place is because one of the buttons in the VCR control would display a grid when clicked. This grid would display under the form controls. The Zorder fixed that problem, but for some reason it screwed- up the relationships. Any idea of how I can get around this?
>>
>>Thanks again
>>
>>
>>>Hi Alan,
>>>
>>>Are you breaking the relationship somewhere in code? Maybe changing the child table's order or setting another relation from the parent with out an additive clause?
>>>
>>>
>>>>I have two textboxes on a form with other controls. The controlsource of the first is Main.txtTypeCode and the second is Type.Desc. They are linked through the data environment. As I skip through the records, the second textbox should display the description of the code in the first textbox, but it doesn’t. I’m doing a ThisForm.Refresh. If I create a test form with just these two textboxes and one command button (to skip), it works fine. Can anyone tell me what could cause such a condition? TIA