I think the easiest approach is, as Mike said, an Update SQL
statement:

UPDATE childtablename
SET counter = counter - 1
WHERE parentrequestid = '$request_id$' AND counter >
'$counterbeingdeleted$'

childtablename = the schema of the child form
counter = field on the childtablename that stores the 1, 2, 3, etc.
parentrequestid = I am assuming you have some foreign key stored on
the childtable that is the Request ID of the parent record.
counterbeingdeleted = the counter value of the record being deleted
(ie 2).

This way you don't have to run through a Push Fields filter.

Steve

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to