Combo boxes (Student database)

[ainyancat]

Views: 18 Size: 203.5 KB">university_updated.zipuniversity_updated.zip

Hello everyone,

I would like you to help me with a small h/w of the course "managing information systems"

Here's the task itself
"Create a form that will allow easily register students for courses with two combo boxes. One combo box will display the information about a student (studentID, Last name, First Name), the other one will display information about the course (catalogNum, Title, Section). The first combo box must take information from the Students table but record the information into StudentsTakesCourses table. The second combo box must take information from the query created earlier but record the information into the StudetTakesCourse table."

I am also attaching the zipped access file.

Generally, we need to create a form with two combo boxes, that will allow us to register students and it should be shown in the table called "StudentsTakingCourses". Even though I made two comboboxes based on the tables written in the task, when I change the info on the form, the info on the table does not change.

Maybe I need to create a new query, or make some sort of a relationship between two boxes?

Looking forward for your help.
Best regards,
Aizada

[cbende2]

No relationship is needed. You are correct in the sense that you have to make a query. You will need to make an append query that: gets the frmRegister student combobox value and gets the frmRegister Course value and then appends to your table "StudentTakingCourses."

EDIT:

I've opened your DB, and you have the first part right. You have a form with two comboboxes that are pulling the correct information.

Things you will need to do:
1. Add a blank textbox to your form, set the control source of this textbox to your combobox's catalog number. You need to look this up since this is your homework assignment... HINT: Column reference.
2. You can hide this new text box if you would like to so it isn't showing anything in the live form.
3. Create an append query that appends to your table.....StudentTakingCourses.
4. in this query you will reference combobox2 for the first field in the query, the second field in the query will reference your textbox that we created in step 1.
5. change your "append to" to the correct fields.
6. Add a button on form that runs your new query.
7. All done.

[ssanfu]

I would suggest you need some work on your table structures.

There are a LOT of duplicated fields in two tables.
"Time" is a reserved word in Access and shouldn't be used as an object name.
Note that I renamed the StudentID fields.....


I would design the form a little differently.
The main form would be based on a query on the Students table. The detail section would have the fields in continuous forms view.

In the main form footer would be a sub form based on a query of the StudentTakingCourses table.
The main/sub forms are linked on StudentID_PK and StudentID_FK fields.
No code required!!


I did add buttons to navigate record, so each button has 1 or 2 lines of code - not required to scroll through the student names, but nice to have.


Using this form, you can select a student, then select the courses required.




PS: I'm not really crazy about the multi-field PK fields. I would use an autonumber field and set a unique index on fields where I want to have unique records.

Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp