Edit a relationship - Access
If your Access database design changes, you might need to change a relationship between tables. In an Access desktop database, you do this by selecting the relationship in the Relationships window and then editing it. To learn more about the ins and outs of relationships, see the. When Charlotte and Dex both saw that things will be difficult, because he lives in Holland, they decided to have a Window glass relationship. Just because the tables are not visible in the relationships window does not mean the relationships do not exist. You can also investigate using.
Contact Name Specifies the name of the contact when the ID is not in the contact database.
DatabaseTools: Relationship Window
Reciprocal If the relationship code you entered in the Relationship field has a reciprocal relationship with another type, the code for that reciprocal relationship type automatically displays in this field.
Status Specifies the status of the contact Active, Marked for deletion, or Suspendedor click the lookup icon to select a value. Note Specifies any notes you want to keep about the contact. Date Added This is a display-only field that shows when a relationship was added.
Last Updated This is a display-only field that shows when a relationship was updated. By This is a display-only field that displays the ID of the person who entered the update to the relationship information. To add a relationship to a customer record Select Customers. Click the lookup icon to open a contact's record in the Manage customers window.
Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider
Select the Relationships tab. On the Relationships tab, click New. The Relationship Detail window opens. On the Relationship Detail window, click New.
Relationship Window - Where Are My Relationships? - Microsoft Community
If you're adding a relationship with a contact that does not exist in the customer database, leave the ID field blank and enter the contact's name in the Contact Name field. In the Relationship field, enter the relationship code, or click the lookup icon to select the appropriate code. If the relationship code you entered has a reciprocal relationship with another relationship type, the Reciprocal field auto-populates. Make your changes, and then click OK.
- Relationship Window - Where Are My Relationships?
- Edit a relationship
- Relationship Detail window
The Edit Relationships dialog box allows you to change a table relationship. Specifically, you can change the tables or queries on either side of the relationship, or the fields on either side.
You can also set the join type, or enforce referential integrity and choose a cascade option. When you are finished in the Relationships window, click Save to save all of your relationship layout changes.
What is the Relationships window?
Edit a relationship in an Access web app The Relationships window isn't available in an Access web app. You use a field in one table as the source lookup field for values in the related field in another table. Open the table that contains the lookup you want to change by clicking Edit Table. Select the field that gets its values from another table. Follow the steps in the wizard to make the changes that you want. You can change the following: