I have a stored procedure which takes a parameter studentID(number). However, my users have a hard time memorizing all studnetIDs, instead, they'd like to input studentName as parameters. Assume the studnetID and studentName relationship is stored in a table studentInfo, is it possible that a user inputs studentName, and crystal report looks up the corresponding studnetID from the table and then feeds studentID to my stored procedure? Or are there any other ways which can achieve the same thing?
I don't want to change my stored procedure to accept a studnetName parameter since this stored procedure is used in many other places, and I don't want to disrupt all others...
Thanks a lot!!!
I don't want to change my stored procedure to accept a studnetName parameter since this stored procedure is used in many other places, and I don't want to disrupt all others...
Thanks a lot!!!