Hmm, that gave me an error saying "Could not find stored procedure 'exec InTransit'", so I took the "exec" out and then it just displaying every single record instead of only grabbing the one I put in the input box.

I'm not sure I understand how it would work unless I could get a WHERE clause in the FoxPro code.

>For the stored procedure it should be
>
>>

text to cmd textmerge noshow
>>[exec InTransit] ?m.fdBlNo
>>endtext

>
>Assuming your SP has just one parameter.