Forum Discussion
Solved
Multiple Payment Methods in one Transaction
Hello, we want to give our customers an overview of what they have purchased using their individual voucher code. The basic setup would be this: There is a transactions table connected to a tra...
I found a solution which gets the correct results, but might be rather inefficent when handling large amount of data.
Basically, you can use another table including all combinations of payment ID and transaction ID which you can use for filtering. Relate that to the transactions table and leave the rest as it is. This should grant you the correct results.
Thanks for your help
If you have any idea how to manage this more efficiently, I'd be thankful
Jayshamone , One way I can think at high level is to merge Trans_payment + Payments into one table and use it
But if I filter the voucher code within the merged table, will I not still only get the payments from the voucher and not the other payment methods?