AnsweredAssumed Answered

Look-up Question

Question asked by jessod20 on Feb 23, 2012
Latest reply on Feb 23, 2012 by RayCologon

Hi All,

I am quite new to this so please forgive me if this is a stupid question or confusing.


I currently have a database that follows-up results of surgeries. I have 2 tables one that collects the operation data and then one that collects scores. These are related by common surgeryID. Each unique surgery can have about 10 scores at different intervals.


I am trying to look up scores through the op data table, so that it can give me each final score at each interval. I have had success with the pre op interval using:


Lookup (( Scores::MHHS: ); If ( Scores::SurgeryIDfk = SurgeryID and Scores::Interval ="Pre-Op";Scores::MHHS:))


However if I change interval in that formula it still gives me the pre op score.


Any guidance on this would be greatly appreciated!