G
Guest
Hello. I have a query which compiles data from two tables, Chargebacks and
Customer Accounts. The problem I'm having is, if a customer has more than one
chargeback for the same dollar amount/bank account number, the query will
only show one chargeback, even though I had a one-to-many join set up to
include all records from the Chargeback table.
Our main problem is that our chargeback file only has two fields we can use
to relate to the customer's account information, the bank account number and
the dollar amount. In order to properly process these transactions to the
customer's accounts, we have to match up the dollars and bank accounts and
add the customer information to the existing chargeback file. At best we are
achieving a 98% success rate.
Customer Accounts. The problem I'm having is, if a customer has more than one
chargeback for the same dollar amount/bank account number, the query will
only show one chargeback, even though I had a one-to-many join set up to
include all records from the Chargeback table.
Our main problem is that our chargeback file only has two fields we can use
to relate to the customer's account information, the bank account number and
the dollar amount. In order to properly process these transactions to the
customer's accounts, we have to match up the dollars and bank accounts and
add the customer information to the existing chargeback file. At best we are
achieving a 98% success rate.