Rick,
>Controls bound to fields in the second table (OrderSetting) dont bind because in the binding code, controls whose BindingSource is not the TableName dont get databound.
Actually they can automatically data bind. Check out the "Data Binding Mere Mortals Windows Forms Controls" and "Data Binding Mere Mortals Web Forms" topics in the MM .NET Dev Guide. There are instructions for specifying the table you want to bind to. If you don't specify a table name the binding defaults to the business object TableName, but you can specify an alternate table name.
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