Using data entered in prompt to search database table

Hey, I will try to explain what I want to do:

When I open a document, there will be prompt to enter the EmployeeID. The id entered will be used to search the data source, in this case a database table, and data like name and phone will be retrieved and displayed on the word document like shown:

EmployeeID: (from the prompt)
Name: (from database table)
Phone: (from database table)

I am able to do the first part. I did it by using a fill-in box. I recorded a macro which selects the fill-in from Quick Parts from Insert. But I have no idea on know to do the rest of the part.

Some help will be greatly appreciated.

Thanks pike. That is a impressive example. But I was looking for some simpler way involving word and macro. I don't know much about the VB codes.

Oh, one thing, about the problem I asked, is it possible to accomplish this task using only word and macro?

Thanks pike