>Thanks for the reply. I don't have a problem with returning the three records I want, the issue is data binding. From what I know, seems the best way is to create three seperate views in the business object. Seems strange to me because the views are identical (expect for the name), but looks like one needs seperate views as text boxes on the form need to be bound to different records.
Creating separate DataViews is the best way to go since Windows Forms binding needs to know the "Current" row to bind a textbox to and there can't be three current rows at the same time. I take it you can't simply display the three rows in a DataGrid?
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