I am trying to figure out, and then update, an old database that uses a Query to populate a Report. In the SQL Statement: Query Builder that is used to populate the report, two of the fields don't have regular entries that correlate to fields on a table, but have a sort of "composite" or "built-up" entry of the format: Table_Field: Field. I can't figure out what this is or why it is different, BUT IT WORKS!!! So obviously it isn't a typo, it was entered on purpose, and I'd like to figure out WHY.
The basic format of the database is two independent tables, let's call them tReports and tRequirements. A third table connects these two, and each report can be associated with multiple requirements, and each requirement can be associated with multiple reports. A fourth table, tCategory, is "on top" of the requirements table to divide the requirements into, duh, categories. Categories have a 1 to many relationship to Requirements.
The report prints out a page for each report with the requirements listed for that report, and the requirements are divided into categories.
For the field in the Query Builder where I would expect the Field to be "CategoryName" and the Table to be tCategory, the Table is as expected, but the Field has instead "tCategory_CategoryName: CategoryName".
If I use a drop down to just select CategoryName, the report doesn't work right, it asks me which CategoryName I want when I open the report, and obviously something is wrong.
Can anyone tell me what this is? I've tried searching "_", query codes, and other things but I can't link in to the right name to even learn more about this. Thanks in advance!
The basic format of the database is two independent tables, let's call them tReports and tRequirements. A third table connects these two, and each report can be associated with multiple requirements, and each requirement can be associated with multiple reports. A fourth table, tCategory, is "on top" of the requirements table to divide the requirements into, duh, categories. Categories have a 1 to many relationship to Requirements.
The report prints out a page for each report with the requirements listed for that report, and the requirements are divided into categories.
For the field in the Query Builder where I would expect the Field to be "CategoryName" and the Table to be tCategory, the Table is as expected, but the Field has instead "tCategory_CategoryName: CategoryName".
If I use a drop down to just select CategoryName, the report doesn't work right, it asks me which CategoryName I want when I open the report, and obviously something is wrong.
Can anyone tell me what this is? I've tried searching "_", query codes, and other things but I can't link in to the right name to even learn more about this. Thanks in advance!