Data Error through Relationships
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?