To remove a table relationship, you must delete the relationship line in the Relationships window. Position the cursor so that it points to the relationship line, and then click the line.

Create, edit, and delete relationships between tables by using the Relationships window.

If Access automatically creates a join that you do not want, or if you create a join by mistake—for example, a join between two fields that have dissimilar data types—you can delete the join.

When you enforce referential integrity and choose the Cascade Delete Related Records option, and you then delete a record on the primary key side of the relationship, Access automatically …

If you need to delete records only on the "one" side of the relationship, you first delete that relationship, and then delete the data. If you need to remove data only on the "many" side of …

Training: The Access Lookup Wizard establishes a relationship between tables. It creates a foreign key that refers back to the primary key of another. Watch this online video.

Right-click a relationship line that connects two tables and then click Delete. To select multiple relationships, hold down CTRL while you click each relationship.

In addition, before you can delete a primary key or a lookup field, you must first delete the relationships for those fields. For more information, see the articles Database design basics, …

Click the table relationship line for the table relationship that you want to delete (the line becomes bold when it is selected), and then press the DELETE key.

Note: When you remove a relationship, you also remove referential integrity support for that relationship, if any. As a result, Access will no longer prevent changes that result in orphan …