I have a relational database in Zoho, with many related forms (tables). Link between these tables are created with import data lookup field. So as a result, for all tables, the first column is "case_number" Always there is an record for each case in the parent table but not always for a child table (because there are no entries for some cases in these child tables). I created separate views for all tables. I need a solution to force all views to show just the records for a desired "case_number" and create a "html combined view" with all these views in order to visualize at once all the records for a desired case. I tried different strategies but with no success because of Zoho limitations in viewing specific data. Maybe the proper strategy should be like here https://help.zoho.com/portal/en/community/topic/accessing-the-last-record but there is more scripting and I can't manage this myself.