Hi Experts I need help...
I have 2 files
File 2 - destination table
There are few columns common in the 2 files...like IdNumber, Name, Manager,
Dept, etc.

My question is when IDNumber is entered in the destination file all other
common fields should get populate automatically?

Please help me this is very urgent...