Hi,

I have Form A - Employee Self Appraisal Form and Form B - Manager Appraisal Form.

Form A - Employee Self Appraisal Form will have all the fields like Employee_ID, Employee_Name and Self Appraisal as text field entered by employee.

Form B - Manager Appraisal Form will have Employee_ID field as lookup field which helps to auto-populate Employee Name and Self Appraisal field. Now Manager will look at the data fetched against each value from lookup field and adds his comments in comment field.

Since the manager might have more than one employee reporting to him, we have to hide/disable the value in Employee_ID lookup field in Manager Appraisal Form once it is submitted for one particular Employee_ID/value.

Manager shouldn't see that value or he should see it is disabled.

Please help me with some code to solve this problem.