Zoho Creator SaaS app with multiple client AND multiple users

I am close to finalizing a Zoho Creator app that will be used by different companies to manage sale info, and each company can have multiple users using the app.

Things were going perfectly until I tried a search on a report. I use a database field in each table to separate the data for each company, which works great. BUT when I do a search, I get to see ALL the data. This means that Company A could easily see the data from Companies B and C via the built-in search.

Is there a way to set up the app so that any user from Company A can only see their data, and any user from Company B can only see THEIR data? I know I can keep users from seeing the data from other users, but this is not the issue; the issue is USERS from a single company not being able to see data from another entirely different organization.

This is a serious deal-breaker for me. If I can't do this without significant changes, Zoho may not be the tool I need, and I've already invested time and money in it.