Hi, everybody,
I have such problem:
I want to generate hyperlinks for every patient, so if I have patient number MRN and I want to generate hyperlink for every patient to folder which name is the same as MRN (exp: jacket\25647).
What I did, I created Field [PatientJacket] as hyperlink and did update query to update PatientJacket field with : 'jacket\' & clinic!MRN
But I got all fields with name of hyperlink (Text to display) 'jacket\[MRN]' and with blank hyperlink address value. Do you have any idea how to update not only hyperlink name, but also address value?
Thank you.
I have such problem:
I want to generate hyperlinks for every patient, so if I have patient number MRN and I want to generate hyperlink for every patient to folder which name is the same as MRN (exp: jacket\25647).
What I did, I created Field [PatientJacket] as hyperlink and did update query to update PatientJacket field with : 'jacket\' & clinic!MRN
But I got all fields with name of hyperlink (Text to display) 'jacket\[MRN]' and with blank hyperlink address value. Do you have any idea how to update not only hyperlink name, but also address value?
Thank you.