I am trying to generate a report, using some options that the end user selects from a combo box on a form or, if possible, right from the queries that generate the report.
The combo box has a list of memo fields that the user can choose to use when populating the report. My problem is that the memo fields are stored in separate tables, categorized slightly differently, and I have not been able to figure out how to get the information from the different tables into the report correctly. Below I will try to explain the objects I am working with:
Memo Fields:
[CaseNote] – field located in table [tblCasesMain]
[SARInfo] – field located in table [tblSARlst], additionally this table also has a field called [SARType] that describes [SARInfo]. Example: [SARType] value can be, “Original” or “Supplemental”
[SynopsisInfo] – field located in table [tblSynopsis] additionally this table also has a field called [SynpopsisType] that describes the [SynopsisInfo] field. Example: [SynopsisType] can be, “Original SAR Synopsis”, “Case Note Synopsis”, or “Incident Report”*
Linking Field:
[CaseNum] – Links all of the mentioned tables to [tblCasesMain]
Reports:
[rptIncidentReport] – main report opened containing various other info including the subreport [sbrIRSummary].
[sbrIRSummary]* - subreport that displays one of the chosen memo fields based on the users selection.
Queries:
[qryIRSummary]* - is the query I originally thought could collect all of the memo fields and be used to choose and populate which one displayed on the subreport [sbrIRSummary].
[qryIncident Report] – is used to populate most of the other information in the main report [rptIncidentReport].
*These asterisked fields/controls/objects are not required to be kept and can be changed as needed to accomplish the goal mentioned. Quick list: “Incident Report”, [sbrIRSummary], and [qryIRSummary].
I tried to explain as much as I thought relevant, but please ask if any clarification is needed.
The combo box has a list of memo fields that the user can choose to use when populating the report. My problem is that the memo fields are stored in separate tables, categorized slightly differently, and I have not been able to figure out how to get the information from the different tables into the report correctly. Below I will try to explain the objects I am working with:
Memo Fields:
[CaseNote] – field located in table [tblCasesMain]
[SARInfo] – field located in table [tblSARlst], additionally this table also has a field called [SARType] that describes [SARInfo]. Example: [SARType] value can be, “Original” or “Supplemental”
[SynopsisInfo] – field located in table [tblSynopsis] additionally this table also has a field called [SynpopsisType] that describes the [SynopsisInfo] field. Example: [SynopsisType] can be, “Original SAR Synopsis”, “Case Note Synopsis”, or “Incident Report”*
Linking Field:
[CaseNum] – Links all of the mentioned tables to [tblCasesMain]
Reports:
[rptIncidentReport] – main report opened containing various other info including the subreport [sbrIRSummary].
[sbrIRSummary]* - subreport that displays one of the chosen memo fields based on the users selection.
Queries:
[qryIRSummary]* - is the query I originally thought could collect all of the memo fields and be used to choose and populate which one displayed on the subreport [sbrIRSummary].
[qryIncident Report] – is used to populate most of the other information in the main report [rptIncidentReport].
*These asterisked fields/controls/objects are not required to be kept and can be changed as needed to accomplish the goal mentioned. Quick list: “Incident Report”, [sbrIRSummary], and [qryIRSummary].
I tried to explain as much as I thought relevant, but please ask if any clarification is needed.