Master/detail subform on regex

[ONM]

11.12-Elba Platinum on TurnKay LAMP, Debian 10 Buster, Apache and MariaDB

I have a relationship between 2 tables where for example, MASTER table has a record with key:
name27
and DETAIL table also has a matching record:
name27
but also has (regex) matching records:
name27-1
name27-2
so 3 matching records in total

In the detail display for name-27 I am already display the name-27 DETAIL record but I also want to also display the other 2 "matching" rows in the details table. To me that seems like a regex relationship.
I was thinking about creating a view of of the DETAIL table with an additional column and a function to strip off the trailing -1s and -2s

So the VIEW schema would look like

name27 name27
name27-1 name27
name27-2 name27

And then create the subform on the VIEW to display

MASTER
name-27

DETAIL
name-27
name-27-1
name-27-2

What are the implications? There are only around 2-3K records in MASTER and 10-20K in DETAIL

Is there a better way?

Thanks

 

[eugenio]

Hello,
interesting solution. I don't see particular implications, if you see performances problems, they will be on MariaDB side, DaDaBIK uses your new field as a normal field.

Best,

—
DaDaBIK Support
dadabik.com