I have an application where the user wants to know the list of Codes that are linked to a Prime Code, but he will search and filter by the Code itself. A manual solution would be, after it performs the filter by Code, to filter the corresponding Prime and then clear the initial filter to have the complete list.
Example: User filters code 414800:
Now he filters the corresponding Prime Code:
Finally, he clears the Code filter. Now he has the complete list of Codes that are related to the Prime Code of the initial Code that was searched:
I would like this process to be done naturally after the user searches for a Code.
I thought of creating a Chain ID for each Prime and dualizing, but I don't see a way to relate this directly to the filter, because it will always look for a Code, never the Prime Code.