Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How Do You Edit An Existing Relationship In Microsoft Access?

April 26, 2017edit existing Microsoft relationship

0

Posted

How Do You Edit An Existing Relationship In Microsoft Access?

1 Answer

0

Posted

If your requirements for information retrieval change, it’s simpler and quicker to edit an existing relationship in Microsoft Access than to delete it and start over. These instructions are for Access 97. Close all tables that are open. Use the F11 key to open the Database window. Click the Table tab. Click the Relationship icon on the toolbar, or select Relationships from the Tools menu. A window appears displaying your relationships. Locate the tables that you want to change, then double-click on the line that joins them. A window appears. Edit the relationship options using the guide in the window. Click to set referential integrity if desired. Referential integrity ensures that relationships between related tables are valid and that you don’t accidentally delete related data. Click OK.