1 Reply Latest reply on Nov 5, 2014 7:13 AM by philmodjunk

    The table that wont go away



      The table that wont go away


      I created a table some time back, deleted the TO and forgot about it.  Now I would like to revisit the table and when I create a layout based on the table, there are quite a few records, all blank with the exception of a foreign key that is likely the original relationship key.  If I delete the records, it deletes the entire record from the formerly related table.  How do I get rid of the relationship, if I cannot see it???

        • 1. Re: The table that wont go away

          That doesn't sound possible. It sounds like you have another table occurrence in your relationship graph based on this same table. You have to have at least one in order to use a layout to display this data. (Perhaps you added it back before creating the layout.)

          I suggest opening Manage | Database | Relationships and selecting the table occurrence that you have specified for this table. Then click the "select tables" button just to the left of the percent magnification box and choose "Select tables with same source table" to see every occurrence with the same data source table highlight.