Basically I have a table full over various incidents with an employee ID attached to each incident. Is there a way to have a separate section where you can type in the an employee ID and it will populate all the incidents (rows in the table) that have this corresponding employee ID? Right now I have to manipulate the table or do ctrl+f to find all the times an employee has been in an incident. Just looking for a cleaner way.
I know I can export to excel and do a vlookup function to achieve the same thing, but I like to keep everything in Access (if possible)