Question: how to change relationship in ms access?
Answer: Double-click the relationship line. On the Design tab, in the Tools group, click Edit Relationships. The Edit Relationships dialog box appears. Make your changes, and then click OK.