Does anyone know how to use ODBC to get a list of payment transactions and the invoices that the payments are applied to? I know the payments are in the transactions table, but I'm not sure what other table I need to do a JOIN against to find the invoices that the payments were applied to?