I have a couple of UserIDs that are tied to the same parent ID.
When a user with the ParentID authorization logs in to view a table record the correct record ID and number for the filtered UserID displays however the record name displays the name of the recordID from the first UserID that the current user has access to .
For Example below table is the actual record values in the table which user ID displays correctly when they log in
UserID RecordID RecordName RecordValue ParentID
UserID1 101 Apples 10.00 ParendID_A
UserID2 101 Oranges 20.00 ParendID_A
UserID3 101 Grapes 15.00 ParendID_A
However, when ParentID_A logs in, the records are displayed as:
UserID RecordID RecordName RecordValue ParentID
UserID1 101 Apples 10.00 ParendID_A
UserID2 101 Apples 20.00 ParendID_A
UserID3 101 Apples 15.00 ParendID_A