Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2005
    Location
    Portland, Oregon
    Posts
    40

    Question Unanswered: Replace Primary Key in two related tables

    An Access database i've inheirited contains two related tables, "tblGroups" and "tblMeetings", whose primary keys are VBA generated using info from each record.

    This is more complicated than it needs to be as we only have about 900 records and don't expect much growth.

    I would like to replace the PK's to a more simpler Autonumber method so we can use a web frontend rather than an Access frontend.

    The table tblGroups is the main table with "GroupID" as the PK. Table "tblMeetings" is the related table with "MeetingID" as the PK using "GroupID" as the relation.
    Last edited by hildebran; 01-06-05 at 21:02. Reason: Ease of reading.

Posting Permissions

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