Ok, All this is my last question for the day!
Still working as a novice on the hospital infection surveillance database.
I've created two different forms to capture two different types of infections FrmVAP and FrmCLABSI.
The problem is that I had to edit the tables related to the form and the form would no longer work.
So, I created two different query with all the needed fields to use as the control source for the individual forms. My quandary is how to link the query to the tables. As it stands, the parent tables is linked to all of the non-parent tables in a 1-to-many relationship.
My question is how do I link the query? For the FrmVAP,do I link the query to the parent table and the VAP table with a one-to-many relationship? I'm just not sure how to conceptualize the problem.
Still working as a novice on the hospital infection surveillance database.
I've created two different forms to capture two different types of infections FrmVAP and FrmCLABSI.
The problem is that I had to edit the tables related to the form and the form would no longer work.
So, I created two different query with all the needed fields to use as the control source for the individual forms. My quandary is how to link the query to the tables. As it stands, the parent tables is linked to all of the non-parent tables in a 1-to-many relationship.
My question is how do I link the query? For the FrmVAP,do I link the query to the parent table and the VAP table with a one-to-many relationship? I'm just not sure how to conceptualize the problem.