>Just a guess, but have you tried binding to the Programs table instead? I'm not sure which would be the correct syntax (I haven't messed around with Relations, so I may be way off base):
>

>this.txtProgramName.DataBindings.Add("Text",this.dsTables.Programs,"Schools_Programs.Name");
>this.txtProgramDesc.DataBindings.Add("Text",this.dsTables.Programs,"Schools_Programs.Description");
>
>// - or this -
>
>this.txtProgramName.DataBindings.Add("Text",this.dsTables.Programs,"Name");
>this.txtProgramDesc.DataBindings.Add("Text",this.dsTables.Programs,"Description");
>

Bonnie:

Thanks for replying. On your first suggestion I get a runtime execption, on the second, the navigation of moving the SHCHOOLS row does not update the txt boxes.

I have found a possible clue. I can Undo the changes with:

this.txtProgramDesc.DataBindings["Text"].BindingManagerBase.CancelCurrentEdit();

But this only rejects changes on the current row. Any other rows in PROGRAMS is still not reverted.

Is there a way to loop through the PROGRAMS and CancelCurrentEdit for all rows?

Thanks!

--Paul