John,
>The only DataGridView on the form has its datasource set to the view. The bindingsource can't be set because I can only choose a single table and this would override the display of the view.
I think this is the crux of the matter. Even though you are using a view to retrieve data, ultimately, it is returned into a single DataTable within the associated DataSet, and you *can* bind to this DataTable.
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