I have an application I'm creating to track engineering changes. It has a junction table, joining a "tags" table, and the "events" table.
I need a search function that will allow them to search for events that are tied to specific tags the user chooses to search.
So, to clarify, the user would choose the tags like "Software A", and "Report Issue"
Then I would find the ID for these tags in the table for tags, then search for events that have 2 supporting records in the junction table (1 with Software A's ID, and 1 with the Report Issue's ID).
Just looking for the most efficient route.
I thought about loading a recordset in VBA with an SQL statement using the first filter, then query that recordset with the second criteria, Creating a 2nd recordset with that data, then query that with the third criteria, etc. But it seems like there has to be a more efficient method.
Thanks.
I need a search function that will allow them to search for events that are tied to specific tags the user chooses to search.
So, to clarify, the user would choose the tags like "Software A", and "Report Issue"
Then I would find the ID for these tags in the table for tags, then search for events that have 2 supporting records in the junction table (1 with Software A's ID, and 1 with the Report Issue's ID).
Just looking for the most efficient route.
I thought about loading a recordset in VBA with an SQL statement using the first filter, then query that recordset with the second criteria, Creating a 2nd recordset with that data, then query that with the third criteria, etc. But it seems like there has to be a more efficient method.
Thanks.
