John,
>The table's PK is included in the view. I need to retrieve the PK when clicking on a record in the view so that I can synchronize the view with the primary table. If I use a datagridview for navigation which is populated by the primary table I get a list of memberids rather than names so I'm unable to make a choice for deletion for instance. I hope that makes more sense.
Sorry for being dense on this one, but maybe you can provide more detail so I can understand the scenario. Are you working with multiple grids? If so, what are you data binding them to? What synchronization are you trying to perform?
>Perhaps you would be good enough to answer another question without me starting another thread - I am trying to use a mmdatetimepicker to input a date. The sql table data type is "datetime". When I try and save a record I get the error that the date is not within the permitted range.
I'm not sure why you're getting the error on the DateTimePicker...you may want to set a breakpoint and see what value it's trying to save.
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