I have 2 tables: A and B. A is linked to B with 1:m relationship.
Table A stores quote information - name, address, total cost of building quote.
Table B stores the list of services for a particular quote (linked to table A) - such as quote service (bathroom, kitchen, roof), cost of service, etc
There is a way to calculate the total cost of the "cost of service" column in table B, by editing "report attributes" and ticking sum.
But how would I get that sum (for cost of each service on table B for a particular quote) to show in the form field "total price" on table A??
Surely there must be a way to link them together.
Do I have to do it outside Apex, on SQL?
Newbie.
Here is photo to help you understand
I think some sql calculation (maybe pl/sql) is needed in the source box. Maybe I should do it on sql first. I need advice on how to do this.
