Show results in table that have current user's company

Need help Database
1

I’m building an employee management system. I have three databases: company, user, and employees (which displays employees’ data). I should mention that my software supports multiple companies and all data will be shown if they belong to that company. Otherwise, it will be hidden.

Info about databases:
company database has two fields in the database: employees (list of users), and company name (text); employee database has a lot of fields but it is connected to company database through ‘field: company. Type: company’; and for user database, it is connected company the same way the aforementioned is.

My Challenge:
I have a table that is connected to the employees database and works perfectly, but it shows employees of all companies. I want it to show employees that match the current user’s company.
Here are screenshots:
table employees
search for employees

2

The Company Field on the User datatype is of ‘type’ Company.

So the value you enter for the search constraint Company must also be of type Company.

Currently the value you’re entering is a Text.

So remove the company_name part from the expression.

3

I’ve done that, and it shows no errors now, however there is not a single row that is shown. It assumes in the front end that there are no matches, but the back-end works fine. Take a look at this picture:

no results
no results1446×227 6.08 KB

database results

4

What does the debugger show for the RG data source?