I have a Product Table (parent table) which has products of different categories and then various Specification tables (children tables) for each specific category - Product_Specs_cat1, Product_Specs_cat2, etc.
Now, When in detailed view of the the product, I want to load all the fields from the child table of that particular category of the product being watched to load seamlessly alongwith the the fields of the parent table.
I know virtual column is the solution but is not practical to create virtual columns where there are a lot of fields in the specs table.
The second solution is inline views but that again is not the best thing. It is only one row after all and neither of the views would show all the fields.
It would have been nice…If there was a possibility to call entire child table fields in one virtual column and a view to customise like we customise the inline view.
Dashboard is one other thing but again not the best experience I feel.