populate the fields
 

Hi Experts I need help...
I have 2 files
File 1 - Source File
File 2 - destination File
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...

Thanks for any help