AnsweredAssumed Answered

Lookup problem

Question asked by mark_d2x on Mar 3, 2010
Latest reply on Mar 4, 2010 by philmodjunk


Lookup problem




I am struggling with a lookup.


I have created a table called IMAGING that has the following fields:


DATE            PROCEDURE            RESULT 1     RESULT 2       RESULT 3


I have set up a table for the lookup for procedure _procedure



Bone Scan

Liver Ultrasound



This is the short version for result 1


INVESTIGATION                       RESULT  1                                  

Bone scan                                 No boney metastases

Bone scan                                 Boney metastases

Bone scan                                 Uncertain boney metastases

Liver ultrasound                        Normal Liver

Liver ultrasound                        Liver metastases

Liver ultrasound                        Liver uncertain

CT CAP                                       Normal

CT CAP                                       Abnormal (cancer detected)

CT CAP                                       Inadequate (incomplete or technically unsatisfactory)


Result 2 would be


CT CAP                                      T0

CT CAP                                      T1

CT CAP                                      T2

CT CAP                                      T3

CT CAP                                      T4

CT CAP                                      TX


with no results  for bone scan or liver ultrasound


I am not sure how to set this up so that the drop down  for PROCEDURE shows the investigations and Result 1 only shows the results for the according to the PROCEDURE.


My first problem is with the lookup and the second with the relationships.


Thanks for helping out with this