G'day,
I had a relationship between my Employee file and another 1-Many file (tblJobTitle) in my relationship diagram. So when I open the Employee file I have records with a plus (+) sign on them. When I click the + on one of the records I can see the related tblJobTitle records.
After some thinking about the design I decided that I did not need the relationship between the two tables so I deleted the 1-Many table without first deleting the link between the two tables.
However when I open the Employees file I still see the + on the LHS of each record and if I click on same the old tblJobTitle records are still there.
I am wondering what I need to do to destroy the old relationship?
I had a relationship between my Employee file and another 1-Many file (tblJobTitle) in my relationship diagram. So when I open the Employee file I have records with a plus (+) sign on them. When I click the + on one of the records I can see the related tblJobTitle records.
After some thinking about the design I decided that I did not need the relationship between the two tables so I deleted the 1-Many table without first deleting the link between the two tables.
However when I open the Employees file I still see the + on the LHS of each record and if I click on same the old tblJobTitle records are still there.
I am wondering what I need to do to destroy the old relationship?