Team level 'User ID' not working (v2025)

I want to have a team-level database, where multiple users can insert and edit each other's records. I did this by adding an extra field to the users table: [team_id:int]. I set this id equal for users from the same team.

and the products table has product info and the extra field [team_id:int], where products for team 1 has id set to 1, etc…

In PHPMaker 2025, I enabled the UserID feature and set the User ID to be team_id, and in the products table select also UserID as team_id.

But when generating and running the app, the users see everything, not just their team's work.

Shouldn’t this work out of the box like this?

That should work, make sure you have not set up "Access" permission for the user level, read Permissions for details.

1 Like

v2025 has both Admin and Access, had Admin off but access on.

thanks