>As I navigate through a dataset I want to save a value in a related table to a public variable.
If you create a child business object that retrieves data from the related table, you can register the child business object with the parent (the one that owns the DataSet you're navigating through) then put code in the child object's HookParentNavigated() method to retrieve the associated row. The HookParentNavigated() method receives the primary key of the parent object (in e.PrimaryKeyValue) to make it easy to retrieve the associated data.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com