The application i am working is connected to sql server 2000 as database. And vb 6 as front end.
I have a form with multiple fields. What i want is ... that when i enter an employees Id in the field... On its lost focus event, The application populates the salary field of the form against that ID.
You could write a Stored Procedure on your database that returns the salary for a given EmployeeID. For something as simple as this you could also send a direct SQL query and process the results, but I hope you have some security or verification scheme for this and a stored procedure will give you more functionality.