www.hkvforums.com

In Asp.NetMaker V2021.09 I want the user only to see records linked to records with that number.

In advanced security, I select the field for that user, from the user's table. This is an integer.
ie the user identification field is the same as the identified numbers in the table I need to filter

Why would this not work, am I doing this correctly

When I choose activate "reports to" then a show number of other records show with no filter.
I've used this in the past several times.

Make sure that you have enabled User ID Security according to:
https://aspnetmaker.dev/docs/#/securityuserid.html

Also enable debug mode (Tools -> Advanced Settings -> Debug) to check the User ID filter for the running SQL.