
Originally Posted by
batowl
This is what the record source line says: SELECT [Subject Information].[Person ID], [Subject Information].[First Name], [Subject Information].[Middle Initial], [Subject Information].[Last Name], [Subject Information].[Date of Birth], [Subject Information].Sex, [Subject Information].[Parent's Name], [Subject Information].[Name of School], [Subject Information].[Name of School Other Comment], [Subject Information].[Grade of School], [Subject Information].[Role at School], [Subject Information].[Home Address 1], [Subject Information].[Home Address 2], [Subject Information].City, [Subject Information].State, [Subject Information].[ZIP Code], [Subject Information].[Daytime Phone Number], [Subject Information].[Evening Phone Number], [Subject Information].[Cell Phone Number], [Follow-Up Information].[Name of PHN Assigned], [Follow-Up Information].[Date of Physical Exam], [Follow-Up Information].[Examining Physician Name], [Follow-Up Information].[Chest X-Ray Done?], [Follow-Up Information].[Date of X-Ray], [Follow-Up Information].[X-Ray Result], [Follow-Up Information].[IgRA Test?], [Follow-Up Information].[Date of IgRA Test], [Follow-Up Information].[Reason For IgRA Test], [Follow-Up Information].[IgRA Test Result], [Follow-Up Information].[Further Follow-Up Needed?], [Follow-Up Information].[Case Closed?], [General Medical Information].[Physician Name], [General Medical Information].[Physician Practice Name], [General Medical Information].[High Risk Condition?], [General Medical Information].[High Risk Description], [General Medical Information].[Hx of Positive TST?], [General Medical Information].[Hx of BCG?], [General Medical Information].[Current Symptoms?], [General Medical Information].[Cough?], [General Medical Information].[Other Symptoms Description], [Priority Level].[Priority Level], [Screening #1 Information].[Screening 1 Location], [Screening #1 Information].[Screening 1 Location Other Description], [Screening #1 Information].[Date TST 1 Administered], [Screening #1 Information].[Date TST 1 Read], [Screening #1 Information].[TST 1 Induration (mm)], [Screening #1 Information].[TST 1 Result], [Screening #1 Information].[TST 1 Referred to Medical Provider?], [Screening #1 Information].[TST 1 Referred to Provider Comment], [Screening #2 Information].[Screening 2 Location], [Screening #2 Information].[Screening 2 Location Other Description], [Screening #2 Information].[Date TST 2 Administered], [Screening #2 Information].[Date TST 2 Read], [Screening #2 Information].[TST 2 Induration (mm)], [Screening #2 Information].[TST 2 Result], [Screening #2 Information].[TST 2 Referred to Medical Provider?], [Screening #2 Information].[TST 2 Referred to Provider Comment], [Screening Consent Information].[Screening Consent?], [Follow-Up Information].[Latent TB Diagnosed?], [Follow-Up Information].[Treatment Started?], [Follow-Up Information].[Date Treatment Started] FROM ((((([Subject Information] INNER JOIN [Follow-Up Information] ON [Subject Information].[Person ID]=[Follow-Up Information].[Person ID]) INNER JOIN [General Medical Information] ON [Subject Information].[Person ID]=[General Medical Information].[Person ID]) INNER JOIN [Priority Level] ON [Subject Information].[Person ID]=[Priority Level].[Person ID]) INNER JOIN [Screening #1 Information] ON [Subject Information].[Person ID]=[Screening #1 Information].[Person ID]) INNER JOIN [Screening #2 Information] ON [Subject Information].[Person ID]=[Screening #2 Information].[Person ID]) INNER JOIN [Screening Consent Information] ON [Subject Information].[Person ID]=[Screening Consent Information].[Person ID];