I have a simple portal that i have placed a button on the portal row. I have tried just running "delete portal row" I have also tried tying it to a script that has the command "delete portal row". The problem is that if I click the button the row does not delete. Once in a while I can open up filemaker and get it to work but it is very random. I have watched the script get called in "script debugger" and have no errors. But yet it does not delete the record. Any ideas?

 

Thanks

Thom

Is it possible that you allow creating new records in the portal and what you are trying to delete is the empty row? You can check in the graph, open the relationship and see if 'allow creation' is checked on the portal table's side.

In the relationship of the portal. The portal is the child and has Allow creation of records in this table via this relationship and delete related records in this table when a record is deleted in the other table.

 

Thanks

Thom

Small update. I went in and looked at my relationship and canceled out, making no changes and it is working. So it is very random.

The relational 'delete in other' means nothing in this situation. You can still delete portal row by button or script as you are doing. But if you have 'Allow Creation' on, your portal will show a trash can or button on the last row even when there is NO RECORD there to delete. Could this be what is happening?

I would say that is not the case since if I have 4 portal rows and I try to delete the 1st, 2nd, 3rd it does nothing so I don't think it is the not created yet row. I really appreciate your help... Thank you!!!

Okay, well it wouldn't be permissions or you would get a message so let's keep looking...

Do you have any script triggers on the layout? Are you sure the button is within the portal row? Are you sure that the table the portal is based upon doesn't have records which appear the same? Have you counted the related, deleted one via the portal, then counted related again?

Otherwise I suggest you attach a zipped empty clone of your file so we can explore the issue further.

I also wonder if a Commit Record[] step is removing it from the row. Seeing your script would help but file is best. :-)