Once you enter the order number, then you can create a hash table within the sp. And use the same database connection to open crystal reports.

Thank you for reply me Dan..

(It was the my first post. sorry if you couldn't get properly)

But i am asking, all the clients are connected to a one database using...

Thanx a lot. Very usefull..:)