Customized views for a "desired_item_number" in a relational database

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 "item_number"
Always there is an record for each item in the parent table but not always for a child table (because there are no entries for some items in child tables).
I created separate views for all tables.
How can I force all views to show just the records for a variable "desired_item_number" ?
Until now:
- tried to restrict records in views with "set criteria" using a value entered in other form (where I enter the desired_item_number) but is not possible because the field used in "set criteria" is from another form;
- tried to use dynamic "set criteria" but this is not permitted in Zoho creator;
- tried to use functionality based URL to create links that filters the records but in functionality based URL's the parameter should be a value (so desired_item_number=value_from_another_form is not possible in Zoho);
- ON LOAD scripts for views is an old request not implemented in Zoho;

So how can have this working, because I think it is a basic function for any kind of database software...?

PLEASE help!