List box showing only fields that have a current selection
I have a table with 50+ fields in it. many of those fields are people's names. I am trying to create an object that will list only the fields that contain the searched name. if that persons name is in 4 of the 50 fields, list only the 4 fields.
I am ultimately trying to get to an object such as a table or chart that will reduce down to or conditionally display the fields and data associated to the searched name. All other fields should hide.