I would like to build a report using 3 tables.
I am creating the report in the services table. The table to table relationship for Profiles and Goals says one Profile/Goal can have many services. I have selected all of the fields that I want to use in the report as lookup fields.
The report worked....Kind of...
The report shows all of the services and all of the related profiles.. but for some reason the Goals don't seem to be connecting to the report. In other words the Goal Columns are on the report table, but no information is populating in those columns.
I am using a table report and using custom columns, only selecting the columns for the data that I want to show.
The student name that all of this information ties back to is the first column on the report table.