User access permissions to the record

[Behrooz]

Hello.
I have a continiouseform containing 4 records.



I want the first user to only access the first record, and the second user only to the second and 4th lines and the third user to the third line
If anyone can help me, great thanks

Sent from my SM-J701F using Tapatalk

[Micron]

Something about a record (a field) must be able to be associated with a user, be that user ID, their level of permissions, whatever. You would then filter their records based on that association.

[Missinglinq]

This is a very strange scenario, to say the least! You probably need to give us a plain language explanation of how you picture this working!

How do you decide who will be the first, second or third users, for instance...which is in line with Microns advice?

Linq ;0)>

[Micron]

I just took it that 1st, 2nd... was just another way of saying A, B, C... or Sam, John, Mary. Perhaps not.

[Missinglinq]

Hard to say with what we've been given.

Linq ;0)>

[Behrooz]

I just took it that 1st, 2nd... was just another way of saying A, B, C... or Sam, John, Mary. Perhaps not.

TblUser
User Name IdNo
User1 saed 7019
User2 ali 2019
User3 mohammad 1921


TblTimeCard
Id Action OperatorName Date


Sent from my SM-J701F using Tapatalk

[Micron]

as already mentioned - you need a field that is common to both tables. What that is depends entirely on your needs and is up to you.
Create the form query so that only records that have the same common data between them are returned when you apply criteria - again whatever that may be.