Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Accidentally deleted table from Model View

Hi,    I wanted to delete a certain relationship between two tables but instead a complete table was deleted. I marked the relation with the mouse and used the "delete key" to remove it . I see no ...
General Comment
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    You are correct about the behaviour, if you want to delete the relationship you need to rigth click the relationship.

     

    Also be sure to read the pop up menu that confirms what you are deleting. 

     

    For sure you also do this but I always do a save before doing a change in a relationship or delete a table, that way if I do any mistake I can just close and reopen the file.

     

    Maybe you can post an idea on the ideas part of the forum to get the relationship selected when you click and not the table.

Ayeyamstewpig's avatar
Ayeyamstewpig
Frequent Visitor
2 years ago

I found a solution, if ur data is from direct query, u need to go back to file>options and settings>data source settings and right click the dataset>change source>select the same dataset>create and congrats u got to select the table u want again!