If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Main/subform and data entry
I have a mainform that contains student info like stud name, age, and so on.
I'd like to create a new subform with the recordsource is the table DormInfo that links to the mainform by DormID. A user will enter the student name and then go down to input the dorm info. My question is how can I make this subform to display data that are already in the table AND also allow the user to input new data that are not there? Thank you for your help in advance. |
#2
|
|||
|
|||
Main/subform and data entry
You have it reversed. Form/subforms are for one-to-many relationships. One
student (your main form) will not have many dorm rooms (your subform). Other the other hand a dorm can have many students. Now again a form for student can use student table joined to dorm table to indicate what room they occupy without using a subform. -- KARL DEWEY Build a little - Test a little "Tim" wrote: I have a mainform that contains student info like stud name, age, and so on. I'd like to create a new subform with the recordsource is the table DormInfo that links to the mainform by DormID. A user will enter the student name and then go down to input the dorm info. My question is how can I make this subform to display data that are already in the table AND also allow the user to input new data that are not there? Thank you for your help in advance. |
Thread Tools | |
Display Modes | |
|
|