Finished query works like a charm. Thanks for the elegant solution!

select MRN, PTFirst, PTLast, UPDRS.dtmevaluation, blnmedications, MBMScore,

   ADLScore, CTScore, dblStage, DyskinesiaR, DyskinesiaL, MOTORscore

from tblpatient p join viewALLUPDRSScores UPDRS on UPDRS.idpatient=p.idpatient

where...

Well I was writing a reply, got up for an hour or so, finished it, hit post and it did not work so here we go again.

Thanks for all these...