How to know which field is the primary key in a Recordset? Please don't suggest 'assume the first field'.
Printable View
How to know which field is the primary key in a Recordset? Please don't suggest 'assume the first field'.
Open the table in Design view and click the Index item in the menu. This should identify which fields are indexed with other tables.
As far as which one is the Primary Key, it is usually indicated with a key to the left of the field.
duplicated itself. sorry.