Creating new ms sql field to link records across table for easy user recall in vbscript

I'm a newbie with vbscript and i need help creating a concatenated field joining transID, Date and userID in a hidden form field that ties records together across tables giving user ability to save and come back. Because transID is an incremented field transID in each table differ. Once this field is created it will then be dumped into a session variable to be used in subsequent record creation. Any suggestions how to go about this.