I have a table which is used to store information about club members attendance at meetings. It consists of a PK, meetingid (an FK to the meetings table) and memberid (an FK to the members table).

To view the full details I use a multitable view that uses the members and meetings tables as lookups.

My question is how can I retrieve the PK of the meetingattendance table when I click on a record in the view. The datagridview is populated by specifying the datasource as the binding source of the view. I obviously can’t set the binding source to the main table (meetingattendance) so I’m unable to use GetCurrentRowPK()

Any help appreciated.