Form Issue

[kirtney]

I am trying to create a form for data entry. It is purpose is to allow student to apply for multiple course as well as input their various qualifications. The list of subjects they can choose from is in the form of a drop down list. This is also the way they can choose the list of courses they wish to do. Currently the form only allows me to choose one subject or course. What i would like to know is there any way i can make the form allow for more that one course or subject to be selected based on the application number or the qualification ID.
The tables are as follows:
Application (ApplicationNO)
Qualification(QualificationID)
QualificationSubjects(QualificationID SubjectID)
ApplicationCourses (ApplicationNO CourseID)

 

[Trevor G]

This seems to be about creating the relationships between tables, you need a One side for the Student and a Many side for the courses, this would allow you to have a form about the Student with a Sub Form related to all the courses, either taken or applying for.

 

[kirtney]

I was able to fix that problem thanks so much for the help. The issue that I am running into now is in the sub form have created i want to be able to put multiple drop down boxes so that the students can choose the subjects they wish to do . The thing that is happening now is that when i select data in one drop down box it automatically updates all instead of allowing me to set different items in each box. Is there anyway i can set each box to hold different data ?

 

[Trevor G]

Can you upload a sample of the database and state what form you want to be looked at, that will help find a solution. Database size for uploading is 2mg so you might need to compact it first then zip it up.

 

[kirtney]

This is the database the name of the form is application. in the courses subform you would see that I can only enter on one course. Here i would ideally like to be able to provide the users with 4 drop down boxes so that they could enter data

 

[Trevor G]

I have taken a look at your database and sadly I don't think your relationships are as you would want it, you have to many tables acting as a link which isn't necessary.

To achieve your goal of having several drop downs to be able to select topics then they would have to be created within the design of your courses table, not just one drop down that would then allow you to be able to select more than 1 course, you would need to have the 4 fields with unique names you can always change the caption to be the same.