Records on Forms

[thesuggs]

I am creating a database and in the forms i am wanting to list the courses the students are undertaking. the problem i am faced with is that some of them may only take one course whilst others may be taking more.
in the form i want student_ID, course_name1 and dates1. i want a button included that when selected another set of fields names student_ID, course_name2 and dates2 is shown. this may need as many as 5. but i only want the additional fields selected if tehre necessary and not have them blank.
any help would be greatly appreciated

 

[ColinEssex]

What tables have you got?

Col

 

[thesuggs]

Its just a simple database so i only have the Student lookup table, course lookup table and then the overall table. The overall table has got a few entries as i mentioned before the students can participate in a lot of courses or only 1

 

[kabz]

One way of doing that is by using the CheckBoxes on your form when indicating which particular course(s) a student has undertaken.