If the user wants to see the child data set and clicks the corresponding field in the "Parent data listing" the link leads to the next table "Child data listing". Both tables visually identical and there is perceptual difficulty to realize that you are leaving one informational space and entering the other.
The obvious solution would be to make the row of the Parent table expand in accordion fashion and display the child data listing below the parent row. The reason we cannot implement this pattern is that the Child table can have hundreds of data rows as well and all fields will need the same functionality as the search filter, add new etc.
What could be a solution without creating animated transitions?