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,