Jump to content
  • 0
Vipul

How to implement this requirements ? (Store Child table total calculated value)

Question

I Have attached screenshot where i have two pages 1 is Detail Datapage and 2nd is Report Datapage... and 3rd is form Datapage which open on click on + Icon..

 

I have following tables.

1. Quote Master (Quotation Master Information, Quote ID, Company and Contacts)

2.Quote Products (its a child table of quote master where i add products for particular Quote)

No w my requirement is what ever product i add to particular quote i need that total value of products in Quote master table (Example I created Quote ID101 and added 2 Products in Quote Products which total value is $200 i want that value to be added in Quote Master Table)

 

How can i achieve same ?

Thanx in Advance..

VIP

 

quote.jpg

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

@Vipul

There are two ways to implement such a workflow.
1. You can create triggered action to update to Total price of the order when the users submits new item. It most cases, it requires 3 triggers on each event (insert, update, delete) and it is not the easiest thing to implement.

2. The second approach is to create the calculated field on the DataPage level to sum prices of all items per order ID.
Example:

SELECT SUM(Item_Price) FROM Order_tbl WHERE Order_ID = [@field:Order_ID]

You need to change the names of the fields and tables according to your local names.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...