Delete Multiple Portal Rows

[skearton]

Hello, is there a script out there that would delete more than one portal row at a time? i.e. if someone checks the box "delete" for a particular row(s) it would delete all of those portal rows at once, instead of it having being done one at a time as it is now.

[David Jondreau]

Create a number field in your related table. Place it in your portal. Make it a checkbox based on a value list with the only value being the number 1. You can size the field so only the box itself shows.

Create a calc field in your parent table. Set it to =1.

Create a new table occurance of the child and relate it with the same criteria as the portal. Add one more criterion and that is the two new fields are equal.

Write a script that goes something like this:

#

If [Count(new_related_to::primary_key)]

Show Custom Dialog ["Do you want to delete all " & Count(new_related_to::primary_key & " records?"]

#

If[Get(lastMessageChoice) = 1]

Go To Related Record [show only related records]

Delete All Records [No dialog]

Go to Layout [original]

End If

#

End If

#