John,
>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()
Maybe I'm missing the point, but can't you just include the table's primary key in the view?
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