Invoice total field on job table not working
I have been racking my brain trying to figure out whats going on. I have done this a hundred times and it always works. I just cant seem to see what I am missing and I have been at it for two solid days.
I have a Customer table, a job table, a materials invoice table, and a materials line item table. I have all of the relationships set like I would any other time, What I am trying to do is take the total of all of a jobs material invoices and have a field on the job page that shows it.
I have a invoice total in the materials table that takes the sum of all of the line items in a portal on the Invoice layout. That works perfect. I have a field in the job table set to a calculation of the sum of the invoice totals. But that field on the job layout doesnt show anything.
I have been going back and forth from another database that I have that does this exact same thing and it works perfect. So I am comparing the two and they are exactly the same.
Any suggestion on what I could be missing?
Need more info just ask.