sarahrose895
New member
- Local time
- Today, 11:33
- Joined
- Dec 23, 2016
- Messages
- 2
:banghead::banghead::banghead::banghead:
Ok... so I have a very basic database that needs to record the details of each student (ID, name, course) and their module choices (4 modules in semester 1 and 4 modules in semester 2).
I have three forms: studentdetail, semester1options and semester2options.
I have two tables: students (ID, name, course) and modulechoices (ID, S1M1, S1M2, S1M3, S1M4, S2M1, S2M2, S2M3, S2M4).
I can get it to save the studentdetail data to the students table, write the corresponding ID to the semester1options and semester2options forms and save the ID and S1M1-S1M4 data (from the semester1options form) to the modulechoices table.
However, I can't get the S2M1-S2M4 data to save to the modulechoices table on the same row as the corresponding ID and semester 1 module choices.
Does anyone know how to get two forms to populate the same table? I've attached a snip of how it populates it at the moment, which is not what I want. I need all of the data shown in that screenshot to appear on the same row.
Thanks
Ok... so I have a very basic database that needs to record the details of each student (ID, name, course) and their module choices (4 modules in semester 1 and 4 modules in semester 2).
I have three forms: studentdetail, semester1options and semester2options.
I have two tables: students (ID, name, course) and modulechoices (ID, S1M1, S1M2, S1M3, S1M4, S2M1, S2M2, S2M3, S2M4).
I can get it to save the studentdetail data to the students table, write the corresponding ID to the semester1options and semester2options forms and save the ID and S1M1-S1M4 data (from the semester1options form) to the modulechoices table.
However, I can't get the S2M1-S2M4 data to save to the modulechoices table on the same row as the corresponding ID and semester 1 module choices.
Does anyone know how to get two forms to populate the same table? I've attached a snip of how it populates it at the moment, which is not what I want. I need all of the data shown in that screenshot to appear on the same row.
Thanks