Data From Multiple Tables

Need help Database
1

Hello,

I am working on a application where I have multiple tables (data types), and I need to create a report where I can show the data from multiple table and do some operations on it like add and substract and show in the repeating group, how can this be done in bubble?

For Example:-

I have a table A with attributes, ID, Item Code and Quantity,
and table B with same attributes:- ID, Item Code and Quantity

Now I want to show the quantity per Item Code in the repeating group

so, Table A has Item Code:- 11011010 and Quantity:- 500, Item Code:-22022020 and Quantity:- 1500
And Table B has Item Code:- 11011010 and Quantity:- 1000, Item Code:-22022020 and Quantity:- 2500

So the repeating group needs to show:-

Item Code :- 11011010 and Quantity:- 1500
Item Code :- 22022020 and Quantity:- 4000

Hope I was able to explain the problem

can someone help me in this?

2

@mustafa.ali - were you able to get answer to this ? ran into a similar issue and looking for a solution

3

I don’t know if you still need help with this, but I would create a summary table, where we combine the quantities from Table A and Table B, and update them based on a database trigger when an Item’s quantity changes. Then you can pull the repeating group from the new table