Hello Ben

Thank you for your interest in our plugin.

If I understood your request correctly, you're looking for the "Users see and edit only their own data" feature. Please take a look at the linked documentation and let me know if you have some follow-up questions.

If the dependency is a user role, for example, we could make it work.

If I have this table:

This is a manual table which has manually entered IDs from wp_users and roles from wp_usermeta:

So, then I go to create an SQL query based table which will display entries based on user roles using this query:

SELECT  new_table.id AS ID,
        new_table.role AS Role,
        new_table.product AS Product,
        new_table.amount AS Amount
FROM wp_wpdatatable_6 AS new_table
JOIN wp_usermeta AS new_table_1
ON new_table_1.user_id = %CURRENT_USER_ID%
AND new_table_1.meta_value LIKE CONCAT('%', new_table.role, '%')

When I'm logged in with user ID = 1, I see this:

When I'm logged in with user ID = 4, I see the same thing. And when I'm logged in as one of the subscribers, I can only see the rows where role = subscriber:

The only difference is that as a subscriber I don't have access to the back-end, so this confirms it is working on both front and back.

So, we're only left with hiding unnecessary columns, adding names, and so on.

Hope this helps.

You're welcome, Ben, glad I could help.

If you need some further assistance, please feel free to reach out to us.