Hi Amanda, thanks for your response.
Essentially there are 2 pages:
- Vendors Balance (All)
- Vendors Balance (Dynamic Page)
The 2nd one works no problem. I pull that data live and filter by the Dynamic Page.
The 1st Vendors Balance (All) is the page I’m having difficulty with. The reason is because I am wanting to update the entire database list and display all of them on a Repeater.
So the data I want to display is:
DB Vendors - Name
DB Vendors - ID
DB Transactions - Total Payments (Sum) per Vendor (this is currently just individual transaction line items on Transactions DB)
The option is to either update an aggregated field on DB Vendors Item and then query THAT number for the repeater, or
Aggregate the Transactions DB and filter by Vendors somehow.
I simply want to open the Vendors Balance (All) list, press a button and then the data updates and displays on the repeater.
Name, ID and Sum of Payments