I have a subform (frm_ProblemList_subform) within a form (frm_UltraPage)
The subform is populating data from tbl_OfficeVisit and tbl_ICD9
The problem is that I'm only populating data from one column - I would like to populate data from 3 columns instead of one
The 3 columns are ICD9, ICD92, ICD93, from tbl_OfficeVisit and Short_Description from tbl_ICD9
How do I get my subform to populate the other two columns value?
Here is my syntax also see the attachment with the screenshot of the form and the table - the data is fictisous)
ode], [tbl_ICD9].[Description], [tbl_OfficeVisits].[Patien
t_id] FROM tbl_ICD9 INNER JOIN tbl_OfficeVisits ON tbl_ICD9.ICD9_Code=tbl_Off