In that situation, it's not possible to have a single report of records from two tables.
what I would do is make a third table, which will combine the first two. I would create a custom Keyfield, which would be a text field in the format.
Debit-123
Which would be a concatenation of either of the word, debit or credit, depending on the source table, and then I end, and then the record ID number of the source record. That way the key field will remain unique in the target table.
Then I would create two saved table to table imports, which would copy the records from each of the two Source tables into the combined table, merging on that Key Field.
then the question is, how would these two saved table to table imports be run. One option would be to create a formula URL button that would run the two imports and Land the user on the combined page. Or else there could be a pipeline set to run every hour.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------