I am after a solution where a user can search for an inducted user (Just a String using Title field), once the search results are returned the user can click on the returned search results title and then be taken to all results related to that user.
Example, Inductee List contains a user named 'Greg Smith' (Title Field), another List named Inductions contains a Lookup to the Inductee Lists Title field. When a search is performed on Greg the results return several list items named Greg, the user could then click on Greg Smith and be shown the entries from the Inductee list and inductions list just for Greg Smith.
Is this possible or is there another approach I can take?
Using SharePoint Online, Modern Experience.