That then leads to duplication of data in the database .. which is a violation of principles. And this is why I have the button to take you to the record in question.
Speed is important. Communicating to the person who will be doing the tickler is important (ie. the details of why I set the tickler). Avoiding "copying" errors is important. I am going to have to manually type all the information in. Seems like a waste. I think all of these things are quite important. I see the speed and efficiency of this workflow as more important than a small bit of data redundancy. I think having 7 different places for the age of the patient is a poor database design, having some important information associated with a tickler is a good idea.
Since I already have the record present, it makes better sense to just show the record as well with the tickler .. but not embed the same data into two different places.
When I make ticklers based on incoming results (Bone density, Colonoscopy, Specialist consult note wants something done ... etc, etc, etc.) I would like to have access to the original .pdf from within the Ticklers. Would that be hard to do ? It seems it knows the Record's metadata ... but not the original file. Idea: Just add a pdf icon ?