Dufek Posted April 6, 2005 Share Posted April 6, 2005 Greetings, I need some advice on how to fix this problem. I have several portals all from the same table, but each using different fields. Using the "Delete Portal Row" command, instead of just the one selected row being deleted, all the rows in the other portals are deleted also. Anyway to prevent this? I am assuming because they all pull from the same table, this is why it is happening... Any suggestions will be greatly appreciated!! BTW, using Developer 7... Link to comment Share on other sites More sharing options...
Ender Posted April 6, 2005 Share Posted April 6, 2005 You likely have the option checked on a relationship definition to 'Delete related records in this table when a record is deleted in the other table.' Check all the relationship lines that connect to the table you are trying to delete records in. Link to comment Share on other sites More sharing options...
Ender Posted April 6, 2005 Share Posted April 6, 2005 Perhaps there's a self-join relationship with this option selected? Link to comment Share on other sites More sharing options...
Vaughan Posted April 6, 2005 Share Posted April 6, 2005 "I have several portals all from the same table, but each using different fields." Do any of these different portals display the same record? Or does each portal see a different set of records? Link to comment Share on other sites More sharing options...
Dufek Posted April 7, 2005 Author Share Posted April 7, 2005 Well, I checked the suggestion offered by Ender and the check box is not checked. Vaughan, the portals display different fields all from the same table. So I guess the answer is they display the same record...?? Link to comment Share on other sites More sharing options...
Ender Posted April 7, 2005 Share Posted April 7, 2005 Usually different portals show records from different tables. This may be why you're having trouble. Why not have a table for the parent records, a table for the stuff that's in Portal A, and another table for the stuff that's in Portal B? If we knew more specifically what your data is about, we could recommend some possible structures. Link to comment Share on other sites More sharing options...
Dufek Posted April 7, 2005 Author Share Posted April 7, 2005 Ender, this is exactly what I did last night. I made separate tables for everything and it works super. Thanks to you and Vaughan for the help and suggestions, it is greatly appreciated! Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.