I had no idea generally where to post this as I was not sure if this was just a form question or a table relationship question, etc.
I have a database for Student Grades (version 2 -- i messed up version 1 and now have to rebulid from scratch, but that's another story). Please see attached document for list of tables & fields that are associated with this issue, problem.
What should happen is when I open a Form (frm_Blocks) based on tbl_Blocks, I have a subform (frm_Rotations) that is linked to forms based on (tbl_Rotations). Here I will enter the names of the students that need to be graded for a specific clinical rotation. Within the frm_Rotations I have a subform -- in datasheet view (so I guess that's a subform subform?) for something else, which works exactly the way I want (it is also a datasheet view).
What I need to somehow figure out. Is with the frm_Rotations there are 3 yes/no controls. If I click the yes/no control for Case Presentation for example, I would like it to transfer the RotationID & StudentIDs to the new table tbl_CasePresentations without needing to open the form (or it could be a hidden form?) and clicking another button or something to that nature.
Maybe I am just doing something wrong with my relationships or something or perhaps there is a more efficient way of doing this. But this is the way in my mind I thought it could/should work? I won't continue on until I figure out this step in case there are easier ways to do this
Any thoughts or help would be great.