dbTalk Databases Forums  

Traning/Sessins/Subscription

comp.databases.ms-access comp.databases.ms-access


Discuss Traning/Sessins/Subscription in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daedalus
 
Posts: n/a

Default Traning/Sessins/Subscription - 04-19-2010 , 04:17 PM






Hi all

I'm making a training-db, where I have trainings (courses), which each can
have 1 to n sessions. Management can indicate which course a person has to
take, after which each person can subscribe to a session of these courses.
Tables are:
- Persons
- Courses
- CourseSessions
- Persons/Courses
- Persons/Sessions

And on a subscription-form I have :
- subform 1 : persons
- subform 2 : courses the current person has to follow
- subform 3 : sessions of the current course

This works fine, but now I'd like to add a checkbox to each row in the
'sessions of the current course' in order to allow a person to
subscribe/unsubscribe.
I suppose the on/off of the checkbox will result in the creation/deletion of
a row in table 'Persons/Session'.
Is this correct, and if so, how can I do this ? Or is there an other
(simpler?) way to do this ?
Btw, I'm using XP and Access 2003

Many tanx in advance !

D

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.