2 Replies Latest reply on May 22, 2014 9:07 AM by Vicky

    Unable to delete portal row?

    Vicky

      Title

      Unable to delete portal row?

      Post

           Hi all,

           I am having an issue trying to delete portal rows.  I deleted two related records but the portal rows just show as blanks instead of being deleted.  If I type in something in the blank rows, it just creates a new record in my related table. I don't know what I did wrong. How can I fix this issue?

           Thanks,

           Vicky Yu

      Screen_Shot_2014-05-22_at_11.33.45_AM.png

        • 1. Re: Unable to delete portal row?
          philmodjunk

               I can see from your screen shot, that you have a filtered portal to a table occurrence (a box in Manage | Database | Relationships ) named "OrderLineItemsByOrder"

               What is the Filter expression that you are using?

               And if you select each of the fields in this portal row in turn while in layout mode, and check to see what is shown in the Display Data From box in the Inspector, is the text to the left of the :: also "OrderLIneItemsByOrder" or are they from yet another table occurrence?

               And can you spell out, in precise detail, the exact steps you took to delete the portal row?

          • 2. Re: Unable to delete portal row?
            Vicky

                 Thank you! I had a couple of orphaned records in OrderLineItems. I deleted those and the portal rows deleted too. :) The records were being created because every field except quantity was from the table order.  I'm going to try to fix the relationships now.

                 Thanks again,

                 Vicky