Where Clause

Hi Peter

I did create two tables

1. Child Data contains ID, Name and Birthdate
2. Inspection contains Inspection Date, Weight, Height and Head circumference

I had created user role “Kader” who can input the data for that two tables.

Each “Kader” can add, edit and delete child name in Child Data table and add the inspection information in Inspection Table for each Child regularly.

I want each “Kader” had their own data n another can’t access it. I have to tried to add $$USERID$$ ini WHERE Clause, but it doesn’t work. Each “Kader” can see all data. Can you help me? Thanks for your help.