Hello
I haven't used Access for a while, and think I may have a difficult first project. The aim of the system is to allow support analysts to record results of daily checks, backups complete etc. There are 3 different support teams with analysts that are assigned to different check types. I will attach a ERM for you to view for ease of understanding.
What I would like to do is have a combo box on a form that allows you to select a analyst name, then do a query so it matches the analyst name selected to the checktypes assigned to them, via a joining table in a many to many relationship, i.e analyst id and checktype id. Then display these checktypes and in a subform so they can then enter the date, result etc next to their check.
Not sure how I do this though, I know the SQL query required would be something like:
I used to be able to do something similar in ASP, but no idea in Access, even if this can be done? I want the analyst to be able to insert the data they enter via the subform, in the table afterwards also.
Anyone got any advice, I can't seem to find what I'm looking for on the web? Would really appreciate any tips or guidance.
I haven't used Access for a while, and think I may have a difficult first project. The aim of the system is to allow support analysts to record results of daily checks, backups complete etc. There are 3 different support teams with analysts that are assigned to different check types. I will attach a ERM for you to view for ease of understanding.
What I would like to do is have a combo box on a form that allows you to select a analyst name, then do a query so it matches the analyst name selected to the checktypes assigned to them, via a joining table in a many to many relationship, i.e analyst id and checktype id. Then display these checktypes and in a subform so they can then enter the date, result etc next to their check.
Not sure how I do this though, I know the SQL query required would be something like:
Code:
select checkname from tbl_checktype where
tbl_analyst_checks.checktype_id = tbl.checktype.checktype_id and
tbl.analyst.analyst_id (or combo box value) = tbl_analystchecks.analyst_id
I used to be able to do something similar in ASP, but no idea in Access, even if this can be done? I want the analyst to be able to insert the data they enter via the subform, in the table afterwards also.
Anyone got any advice, I can't seem to find what I'm looking for on the web? Would really appreciate any tips or guidance.