AnsweredAssumed Answered

Data Error through Relationships

Question asked by p_pohlhammer on Feb 21, 2012
Latest reply on Feb 21, 2012 by philmodjunk

Title

Data Error through Relationships

Post

In the attached relationship screenshot one record in the Marketing Budget is picking up the value from an adjacent record in the PAID field. This field is using data from the "amount paid" field in the Paid Funds table. All of the other records are correct and I can't figure out why this particular one is not. All of the records in the Marketing table share the same ORG number so I don't think the error is there. It has to be somewhere in the way one of the ACCT numbers is relating, but I can't find it. If anyone has a guess where in the relationship path it might be I'd love to hear from you. I think it has to be somewhere in path linking Paid Funds to the Marketing Budget table. Any other guesses?

Pete P.

Marketing_Budget_Relationships.jpg

Outcomes