>Maybe I'm missing the point, but can't you just include the table's primary key in the view?
>
>Best Regards,

Thanks for replying Kevin.
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.

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.


Thanks,

John