Logical Hooks relate to field

[kingjatin]

Hi All,

I have a module named as resource planner, now is there any possibility that when I enter a new record and fill a field name as employee name then it should fetch out the data from the database of sugarcrm and pre fill with some fields and rest of the fields I can fill.

Say I have a form where I have fields.

Name, Phone Number, Address, currently working over which case.

now whenever I enter a name then it should search for the respective record in the database of employee module and would auto fill the data like phone number, address which are already fixed and then I can fill the field "currently working over which case " and then I can save the record..
I think this can also be achieved by the logic hooks but just I need to play around with the variables and queries.

[kingjatin]

??? Any Help Please...............