Options to hide fields in a portal if they do not contain a certain name (related in another table)
I have a performer history layout that has a portal to another table in my database, The layout shows performers personal detais and the portal shows each of the last five shows and what positions they performed in.
My Problem is that each show record has 300 + fields for positions (all these contain performers names) and when the portal relates back to the Performer history layout I would like it to display only the fields where the current performers name is entered.
I.e in show one, (record#8) Arron performes in Diving Position 1, Diving position 6, handstand position 4 and flip position 8 (these are 4 fileds of 300 or so available in the show table) Is there a way to dynamically show for each day which fields the current records first name appears in?
Hopefully this makes sense.