Hi, and thank you for taking the time in reading my thread.
Database information:
I have three tables; users, clinicians, and RU. The ‘users’ table should have all available users that can login whereas the ‘clinicians’ table only has users that are in the ‘users’ table but also have additional capabilities; their RUs, locations of operation and facilities he/she work in (each clinician is listed more than once based on their capabilities). The table ‘RU’ has each of RUs (in the ‘clinicians’ table) associated with the clinician their areas of operation and the facilities.
Objective(s):
Using MS Access 2002, I would like to search/find a user that is in the ‘users’ table and display these results in a table labeled ‘tbl_users’. Any clinician (if any) displayed in the ‘tbl_users’ would have his/her multiple RUs displayed in another table labeled ‘tbl_clinicians’. And finally, all RUs (if any) would be displayed in ‘tbl_RU’ along with his/her associated facilities and areas of operation.
I’ve tried:
I have limited knowledge with forms. I am able to create two subforms that will display the results of a find/search using a text box and command button. However, every time I create a third subform it wants to reference to the main form (which does not have all of the possible RUs that a clinician may have. It only has one of them) only and not the second form. I think if I could, it might work, which is where you come in.
Plan:
This would allow me to verify data already entered at a glance as well as edit and/or add/delete records to the corresponding tables in the database as needed. If it makes any difference, I hope that this form can be moved to a production database where the MS Access database is linked to data on a MySQL server.
My question(s):
Is what I am doing (subforms, command button, and text box) the best way of accomplishing it, and if not please offer constructive suggestions? Is it possible to associate a third subform to any other form other than the main form and if so please offer information or point me to a resource that can help?
I thank you again and for your suggestion(s).
sseven
Database information:
I have three tables; users, clinicians, and RU. The ‘users’ table should have all available users that can login whereas the ‘clinicians’ table only has users that are in the ‘users’ table but also have additional capabilities; their RUs, locations of operation and facilities he/she work in (each clinician is listed more than once based on their capabilities). The table ‘RU’ has each of RUs (in the ‘clinicians’ table) associated with the clinician their areas of operation and the facilities.
Objective(s):
Using MS Access 2002, I would like to search/find a user that is in the ‘users’ table and display these results in a table labeled ‘tbl_users’. Any clinician (if any) displayed in the ‘tbl_users’ would have his/her multiple RUs displayed in another table labeled ‘tbl_clinicians’. And finally, all RUs (if any) would be displayed in ‘tbl_RU’ along with his/her associated facilities and areas of operation.
I’ve tried:
I have limited knowledge with forms. I am able to create two subforms that will display the results of a find/search using a text box and command button. However, every time I create a third subform it wants to reference to the main form (which does not have all of the possible RUs that a clinician may have. It only has one of them) only and not the second form. I think if I could, it might work, which is where you come in.
Plan:
This would allow me to verify data already entered at a glance as well as edit and/or add/delete records to the corresponding tables in the database as needed. If it makes any difference, I hope that this form can be moved to a production database where the MS Access database is linked to data on a MySQL server.
My question(s):
Is what I am doing (subforms, command button, and text box) the best way of accomplishing it, and if not please offer constructive suggestions? Is it possible to associate a third subform to any other form other than the main form and if so please offer information or point me to a resource that can help?
I thank you again and for your suggestion(s).
sseven