Often, when I join a form to a sub form I find I need to put invisible fields on the form to facilitate the join. I am wondering is this the best way to do things??
A Teacher has many students.
When I am calling a subform to display all the student names (for one particular teacher) I find that I need to put the "TEACHERID" onto the main form and make this (numeric) field invisible.
I am happy to continue doing this but wonder if there is a less convoluted way.
(My example is not very clear but hopefully you will get the meaning)