I am having a problem with Lookup while in security mode.
I want one of my employees to enter in time cards for everyone here. But I dont want him to see what other people are getting paid. When I limit his access to the "pay Rate" field, the Look up function does not look up the rate, so I have to go in and re-enter everyone's employee code so it will pull the rate from the other data base.
Does anyone have a suggestion?
Unless there is an overriding reason to do so, just don't put the rate field or the resulting Pay calculation on the data entry layout. The lookup will still work. Just give your data entry person a layout with the least number of fields necessary to get the job done. Name and number of hours. Print the checks or whatever from a different layout where the data entry person does not have access.