Using data entered in prompt to search database table

[BluRay]

Hey, i will try to describe what I want to do (hope it will be understandable)

"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.

[BluRay]

Someone...........?