Hello Erica

Thank you for your interest in our plugin.

We have a feature Users see and edit only own data, which allows you to select an integer column, which would be used as the ID column of user's WordPress user IDs.

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 subscriber I don't have access to 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.

If you purchase the plugin, and we figure out we can't get it to match your idea, you can ask for a refund within 15 days of purchase.