Is it possible to allow a Project Manager to view all records where their project is mentioned in the lookup field?

It would be very useful and save time since we need to reassign Primary Lookup in all records related to the project when the Project Manager changed.