Adding delegates to a course table

[johnl40]

Hi




I am pretty new to Access 2010 and can't get my head around an issue.


I have a main table ('tbl_CourseSession') which has many fields, one of which is 'Course Session ID' which has a relationship with the 'Course Session ID' in a table named 'tbl_DelegateList'.


So, basically, 'tbl_CourseSession' is a record of all courses and 'tbl_DelegateList' will be a list of all delegates who take these courses - so one course may have 8 individual delegates involved whilst some delegates will be registered onto many courses.


I have created a form ('frm_CourseSession') which allows me to view all the data in'tbl_CourseSession' (plus edit an existing/add a new course) - this form also has a sub-form which will list any delegates who have enrolled for that particular course.


At the very bottom I have two buttons - one allows new delegates to be entered into 'tbl_DelegateList' and this works OK.


The other button (and this is where I am getting mixed up) needs to add a delegate to the course that is currently open in 'frm_CourseSession' - so, this button needs to offer a list of all the delegates in table 'tbl_DelegateList' and then when I choose a delegate, this delegate is added to the course in question.


For some reason, I am getting mixed up with how the delegates would be linked to the table 'tbl_CourseSession', how to create a report to allow a chosen delegate to be added to a course, etc.


Hope this makes sense - if anyone can help, that would be most gratefully received.


Kind Regards,






John

[orange]

John,

Tell us about your requirement in simple, plain English. Forget the Access jargon of forms and buttons for the moment.

What exactly is a CourseSession?

[johnl40]

Sorry about that.


I have a table which contains many fields that detail training courses - this includes dates, venue details, examiner details, book contact, etc - with many check boxes to confirm whether important information has been sent out and/or received.


So this table is an overall record of most aspects of the course.


Another table contains details of the delegates who will take each course - fields include their name, address, organisation, course fee, etc.


I have created a relationship between both.


So, delegates from the delegates table need to be assigned to courses in the training courses table and I need the data to be presented in a form where the top half details all the fields from the training courses table (for editing or new course entries) and the bottom half of the form is a sub-form which shows a list of any delegates that have been enrolled on a course (specifically the same course in same form dialog box). The top half is working OK.


In this form, I need some way of choosing a delegate from a list and associating it with a particular course.


Hope this has simplified matters a little - apologies again as I am new to Access and, whilst I have learnt a lot through online training, for some reason I am having a 'senior moment' when it comes to this particular issue!!


Kind Regards,




John

[orange]

John,

I picked up on the senior moment, but I'm going to ignore that and offer some basic info.

Successful database applications, in general, depend on the ability of that database to support the "Business".
Too many people jump into Access without some knowledge of database. Others think Access is a bigger version of Excel--NOT TRUE!
Videos 1,2 and 4 in this 8 part series Database by Dr Daniel Soper are a good source of info on basic Database concepts.

Also, spending 45 -60 minutes working through this tutorial from RogersAccessLibrary will lead you through a procedure to design your database; its tables and relationships to match your requirements. You have to work through it, but you will learn.

It appears that your current design is not Normalized. You appear to have hidden entities that will cause you issues.

You have to get your tables and relationships designed to match your business requirements.

Try the tutorial, and watch the videos. Post back--we are here to help.