I have tables with relationships setup, but the reports seem to be missing data?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
Below are the relationship diagrams, how I have it set up. I've created a Sample Project, with the intent of that being the general overview, pulling data/reports from other tables, such as the Project Tasks.

So the problem is, the report is generating nothing there, when I have already created a Project Task tied to this Project; and vice versa, if you go into the Project Task, there's a field supposed to pull the Project Due Date, but shows up blank, even when that field is populated in the Project Form.

Any ideas?

Photo of ASullivanFFR

ASullivanFFR

  • 210 Points 100 badge 2x thumb
  • dizzy

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
This is just a guess because I can't look into those fields.

But it looks like there were some changes to the relationship after it was made, mainly that there is no Proxy field on the task table for the project.  So your tasks might be getting associated the right way when you add a task.

Just an idea, but its hard to tell without getting in there.