Need to create Lookup of Deparment from Different Companies

Hi all,

I am having issue in creating lookup of department,

My requirement is I want to create a lookup of department on basis of company (dataAreaid) selected,

I tried this by using change company and lookup is working fine,but when i select the department its showing ,“Value is not found in relating table”.

This error is coming as the value im selecting in department is not there in current company table ,how to resolve this…