Question

How can you edit a relationship already established between two tables? *​

Answer 1

Answer:

On the Design tab, in the Tools group, click Edit Relationships. The Edit Relationships dialog box appears. Make your changes, and then click OK. The Edit Relationships dialog box allows you to change a table relationship.

Answer 2

Explanation:

In order to edit a relationship among tables in Microsoft Access, following four steps are to be followed;

• Click on the Database Tools tab, and then click on the Relationships tool in the Show/Hide group on the ribbon.
• Double-click the line joining the two tables whose relationship you want to modify.
• Make the required changes.
• Click OK. All the normal rules regarding the establishment of relationships will apply.

These are 4 easy steps to change the relationship in tables