How Do You Delete A Relationship In Access 2003?
Access 2003 allows you to create relationships that compare and assemble data. If you decide that a relationship is unnecessary, you can remove the relationship rather than deleting the entire table. Open the Microsoft Access 2003 program. If you have the program set to display the “Task Pane,” all you need to do is find the name of the database that has relationships that you want to delete and left-click. Click the “Display Database Window” button in the “Main Switchboard” window. This brings up the database information, which will be displayed in a new window within the Microsoft Access 2003 main window. Go to the toolbar for the Access 2003 window. Left-click on “Tools” and then scroll down and click “Relationships.” This will bring up a “Relationships” window that displays all of the tables within the database with defined relationships. Right-click on one of the lines that you see connecting a pair of tables. This will bring up a short menu that will give you the option of either
