Does anyone know if it is possible to have one field on a search card, look through 10 different fields on a folder card? I am setting up a place in my vault that will be used for Manufacturing Kaizen events. They want sepereate fields to list out the team members (total of 10) and have the ability to search for a particular persons name associated with that event. On my file card there are 10 different varibles labeled Team Member 1, Team Member 2..... On my search card I would like one field called something like Team Member and have that field look in all 10 field on the folder card.
I hope that makes sense.