I have a client who has requested something that I admit I have no idea how to accomplish without setting up a "side" database for him.

He wants to make it so "certain records" created by a particular employee are not visible to everyone else using the same database.

The values in those "invisible records" still need to be part of summary reports and the like, so it is not like I can exclude them from the main body of the data base.

Does anyone have a suggestion for how I can approach this? I am wondering if I am making more of this request than it really is. If it were possible to password protect individual records that would certainly solve the problem.

Thanks,

Steve

Haven't tried this, so I'm not sure if it'll do what you want, but you can try setting up a privilege set and under record access setting the View to Limited with a calculation = (get(accountname)=table1::createdby) or get(layoutName)="report1" or get(layoutname)="report2" etc. This should (I think) allow certain records to show up only for the creator OR if the layout is a particular report.