I have a "case" record with a PK of case_ID that has a to-many relationship to an "event" that uses case_ID as its parent_ID.
The "event" child has an event_ID as a PK which has several to-one relationships with different "event" detail records which in turn uses the event_ID as its parent_ID. (It also as case_ID assigned as case_number as information but not used in the relationship scheme.)
Inside case I have a series of layouts that displays the details of a single event child at a time with "previous" and "next" arrows to show all the child event records - which are essentially grandchildren. I have a calculated value in case called child_id_for_pipeline which is the event_ID from the current event file. I use that calculated variable in a relationship between case and the event subrecords parent_ID and all that works fine. I can display, edit and scroll through the children and parents and all that.
The only problem I have is that I can't search within those portals. I'm guessing because the value I use to establish the relationship is calulated it works fine for everything but searching - I always receive a "No records match that search" message with cancel and modify options.
One solution I thought of is to make a second relationship that links case_ID to case_number in the grandchildren records and replicate the layout with this relationship when you press the "Find" button but I'd rather have a solution that works even if the user chooses the "find" shortcut rather than forcing people to use the button.
Is there an easy solution I'm missing?