unfortunately i am not sure exactly how to tie the two together...
i am sure there is a way to add the hyperlink to the CCR# each time a new one is created... but not sure how...
I will try a few things...