Raj, What is the reason you need that counter? Just to have a total count of tickets in form 1?? Or is there another reason?
If you just want a count, I wouldn't create a form. I would have a hidden field that did a select count(*) from whatever view name that table has in the underlying database.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Raj Sent: Thursday, April 15, 2010 8:04 PM 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"