Unanswered: Next Referenced Field Displayed on Report
I realize that I've overlooked something in trying to get this to work so I've resorted to asking for some help. Please be kind and remember that everyone is a newbie at some point.
I have 2 tables. Table 1 is a reference table that displays a list of drugs and their side effects and uses. Table 2 is a Patient table that is fed from a form that contains patient name, allergies, med1 (control source from Table1), med2 (control source form Table1) and so on with the different meds they are discharged on.
I have created a report that will include the patient demographics and the names of the meds (med1, med2, etc.) from Table 2 as well as the med specific data from Table 1 (side effects and uses). The problem is that I'm only receiving the the side effect and uses data for med1.
How do I get the report to display the correct med# form Table 2 with the related med info from Table 1?
Last edited by jsolodky; 09-30-11 at 16:58.