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!