I'm building a form where the user selects an employee in a lookup form and I would like to link it to the employee table so I don't need to maintain a separate list of employees. But even when I've created a lookup form with 2 fields of the employee table listed, the filter function can be used to guess at the values of other fields in the employee table. I also don't think it's a good idea or good practice to give permission to the employee table to low level employees at all.
Anyone have any alternative solutions for me?
Is there any way to set read permissions on individual fields of a table?