I am working on a patient/doctor kind of project where by the patient fills a questionnaire and then the doctor provides a prescription.

I have used webform module to create the questionnaire which the patients would fill, and i have created a custom content type for the prescription.

II am working on a patient/doctor kind of project where by the patient fills a questionnaire and then the doctor, provides a corresponding prescription.
I have used Webform module to create the questionnaire which the patients would fill. I have created a custom content type for the prescription.

I need to be able to relate the submission Id of the questionnaire to the prescription but I am not sure how to do it.

I have tried the node reference module but that only gives me access to the questionnaire not submission id of the questionnaire.

Please note that a patient can fill various questionnaires so it is quite important that I use the submission id as it seem as the only unique id available.
 need to be able to relate the submission Id of the questionnaire to the prescription but i am not sure how to do it.

I have tried the node reference module but that only gives me access to the questionnaire not submission id of the questionnaire