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?