Consulting

Results 1 to 3 of 3

Thread: Finding the primary key in a Recordset?

  1. #1

    Finding the primary key in a Recordset?

    How to know which field is the primary key in a Recordset? Please don't suggest 'assume the first field'.

  2. #2
    VBAX Expert Imdabaum's Avatar
    Joined
    Jun 2006
    Posts
    652
    Location
    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.
    Someday I'll understand everything...
    Even then...I'll still pretend I'm a beginner.

  3. #3
    VBAX Expert Imdabaum's Avatar
    Joined
    Jun 2006
    Posts
    652
    Location
    duplicated itself. sorry.
    Someday I'll understand everything...
    Even then...I'll still pretend I'm a beginner.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •