How can I set an additional security filter?
I have a table that contains sensitive data and want to add additional level of security to restrict which records a user can view from that table. My table called “SensitiveData” already contains columns called Passcode1 & Passcode2. So basically I want to present a view where the user has to enter the passcodes (supplied to them separately) in two fields called Passcode1 & Passcode2 then check them against a virtual field which is CONCATENATE(Passcode1,Passcode2). Assuming their codes match then I want to display the records that match that criteria.
Can anyone point me in the direction of how to go about achieving this?