Hi Opela, Thanks for the response.....
On Delete Button i have set an AL which set the record status to No which was initially Yes and hence the record will no longer appear in the Table as the qualification of table is to display only those records which are Yes.So now this record will still exist on the Child Form with status set to No but not in the table on Parent Form. Now as per ur suggestion of creating a filter on the child form of pushing fields to the same form for any record where counter on the current ticket is less than the counter on any other ticket can you elaborate on how to check counter on the current ticket is less than the counter on any other ticket? And if this works will it take a Large amount of time to update the records? Regards, Amey On Wed, Dec 24, 2008 at 9:57 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH <[email protected]> wrote: > I'm assuming that whenever you 'delete' a record, you are simply changing the > status so that it doesn't show up on the table, then refreshing the table. > > You could add a filter that runs on the child form, the one from which the > table is pulling its data, and have that filter run whenever the status is > set to inactive, delete, whatever it is getting set to. The filter will then > do a push fields to the same form for any record where counter on the current > ticket is less than the counter on any other ticket found. Then, simply do > the push fields of Counter = Counter - 1. > > I think that this should work for you. > Order ID Value > 1 Test > 2 Test1 > 3 Test2 > 4 Test3 > > If you deleted 2, then the filter would decrement test2 and test3, giving you > the following: > > Order ID Value > 1 Test > 2 Test2 > 3 Test3 > > I think this will work. There might be a timing issue, however, on the > refreshing of the table. Since you are using a filter, I'm afraid that your > table might refresh prior to all of the tickets in the child form getting > decremented. > > Let me know if it works. > > Thanks, > > Gary Opela, Jr. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Amey Bhosale > Sent: Wednesday, December 24, 2008 10:21 AM > To: [email protected] > Subject: Creating Decrementing value in Table > > ** > Hi All, > > I am currently working on ARS 7.1 and have a query to ask you all. > > I have created a Regular Form on which i have added a table field(holding > data into anothe form) which displays only those records which have a flag > set to "Yes" > > On this Regular Form i have added a "Add/Modify" and Delete Button with some > selection fields on top of this Table field which user will select and either > add to the table or select any record from the table and delete it. > > When user selects the value from selection field and clicks on Add button the > record gets added into the Table Field with an incrementing Value i.e 1,2,3 > and so on..which i managed to do so... > > But now i have a problem in where in if i select a record from Table and > click on Delete Button then that particular record show go from the table and > then the next records order id shuld get updated to previous one and same > follows through rest of the table. > > for e.g Now suppose i have added records as below > > Order Id Value > > 1 Test > 2 Test1 > 3 Test2 > 4 Test3 > 5 Test4 > > Now if i want to delete second record i.e Order id = 2 then when it gets > deleted the third record i.e Order id =3 shuld get updated as Order id = 2 > and then all the below record shuld similarly get updated i.e fourth record > i.e Order id =4 should get updated to 3 and Order id =5 to 4 > > Can someone let me know how this can be implemented? > > > Regards > > Amey Bhosale > > Remedy Application Developer > > J . P. Morgan Services India Pvt. Ltd. > > > > ________________________________ > > Cricket on your mind? Visit the ultimate cricket website. Enter now! > <http://in.rd.yahoo.com/tagline_cricket_1/*http://beta.cricket.yahoo.com> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
