I have a portal in a database. The portal has been set to delete records. I have placed a button in the portal in each row that has been set to delete portal row. But when I hit this it not only deletes all rows in the portal in deletes the entire record that is related to the portal table.

It is an orderform - product items type situation. So I just want it to delete a product item from the orderform, but it is deleting the whole orderform record.

Has anybody come across this? Or am I doing something really obvious/dumb?

Thanks for any hints you can give me.

Cheers, Chris.

Hi-

button should be placed in portal row record and run script:

go to related record

perform script (external)

external script should be in related file:

delete record

you are probably having the button perform a delete record script in the master file, not the related file.

HTH

Another option besides the once given earlier for the portal row delete button is

Set field (GlobalNumberField ,status current portal row).

Go to field (FieldInPortalXYZ) **

Go to portal row (GlobalNumberField)

Delete portal row

** this step needed if there is more than one portal on the layout so that FM knowns whick portal you are referring to.

Good luck

Hi Chris

I would suggest removing the relationship option to "delete related records", which will delete ALL related records. Be sure the relationship "allows creation of related record" so you can enter the portal. The button in your portal row should then be simply "Delete Record". That's all you need! Delete portal row is used when scripting to find a specific row to delete (such as GoTo Portal Row 1 and delete it).

LaRetta

At its simplest, the button needs only to run the "Delete Portal Row []" script step. No need to muck around with any other stuff -- not even a script.

I generally use a script only so I can make a custom message for the interface, but ultimately it uses the "Delete Portal Row []" script step to delete the related record.

If you are still having problems, make sure the button is wholely within the portal -- not overlapping the portal boumdary or even on the line, right inside. If a single pixel is outside the portal FMP treats it as though it's in the master record.