serious autonumbering problem

[saleemMSMS]

i have 2 tables
training program and session

Training Program
============
program ID
description
duratuion
#ofSessions

Sessions
============
programID
SessionID
sessionDate
#Participants

here, in the training program table, the program ID is an AutoNumber Column.

in the session table, programID and sressionID are composite primary keys.
the sessionID starts from 1 and increments for a given program ID
for eg :

at the moment, the session ID is entered manually, my question is, isnt there a way that the session ID can be entered automatically ?

 

[John Big Booty]

Please refrain from Double Posting

 

[boblarson]

Please refrain from Double Posting

Looks like the other post got deleted, so this one is now live.


saleemMSMS -

Your Sessions table should have SessionID as the autonumber and the ProgramID should be a Long Integer to store the Foreign Key (ProgramID from the Training Program table).

Also, you should not use special characters, like #, or spaces in the field or object names. # has special meaning in Access (having to do with dates) and it will make your life MUCH, MUCH easier if you do not use them in field names.

 

[John Big Booty]

........

at the moment, the session ID is entered manually, my question is, isnt there a way that the session ID can be entered automatically ?

Check out the DMAX() Function.

DMAX("SessionID", "Sessions")+1