var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 20:02.
Reason: Ease of reading.