Hi Raj, In your example 'form1' is parent. 'form2' is child. In form2 tickets are created based on ticket created in form1. In this case on 'form2' you must have a required field that hold 'Request ID' for ticket submitted in form1. Create a display only field of type integer on form1.
Define a filter that executes on 'Get Entry' on form1 with a an action 'set fields'. In the action 'set fields' run an SQL that counts how many tickets exists in form2 that reference the current ticket from form1. For reports create a join form based on form1 and form2. Best regards, Daniel -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: vendredi 16 avril 2010 2:04 To: arslist@ARSLIST.ORG Subject: need to design a counter Hello all, There is an integer field on form1. need to design a counter which increments the count by one for every submit on form2. So, need to write a filter on submit of form 2 which increments the integer field on form 1 by 1 for every submit on form 2.please advise. thanks, Raj ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" This message was successfully scanned against all known virusses by McAfee Groupshield. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" ********************************* This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. Messages are susceptible to alteration. France Telecom Group shall not be liable for the message if altered, changed or falsified. If you are not the intended addressee of this message, please cancel it immediately and inform the sender. ******************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"