Apologies in advance, but can you describe this statement in more detail? "one record in the Marketing Budget is picking up the value from an adjacent record in the PAID field. "
What do you mean by "adjacent record"? (What makes them adjacent?)
Do you mean that the Paid field in one record is displaying the result expected for a different record in the same table? Your "adjacent" record?
Does each record in Marketing Budget have a unique value in ACCT?
The infomation posted suggest that Marketing Bugdet::Paid is a calculation field. Please post the calculation used.
Also, please explain the relationship between invoices and Paid Funds the purpose for the Paid Funds table. I can see that from a given invoice, it will link to all records in Paid Funds that have the same ORG, Acct and payment status as the current invoice, but don't quite see the purpose to that relationship here.