I have a table, named tblRecords, and a joined table, named tblUserRecords. The tables are one-to-many joined by RecordID.
In tblRecords, I have a field named UserID to show who entered the record.
In tblUserRecords, I also have a field named UserID for user(s) who have access to the record...