Relationships link one Table to another. This article explains how to Create, Edit and Delete a Table Relationship in Microsoft Access.

To delete an ID field in a Microsoft Access database, it might be necessary to delete the relationships between it and other tables. Fields can be deleted in a table using either the Datasheet ...