The typical area from primary table needs to be a major trick or have a unique directory.
The most popular industries need similar data type. The only difference would be that an AutoNumber field tends to be pertaining 
to several industry that has a FieldSize house environment of lengthy Integer.
Both tables exists in identical Access database. Referential integrity should not be implemented on linked tables. But in the event that resource dining tables have been in accessibility structure, it is possible to opened the databases for which these are generally kept and enable referential stability where database.
Arranged the cascade options
You may come across a situation for which you need a valid must alter the price in the “one” area of a commitment. When this happens, you will want accessibility immediately revise all of the impacted rows included in one process. By doing this the up-date is completed completely so your databases just isn’t left in an inconsistent condition aˆ” with a few rows up-to-date and a few not. Accessibility helps you avoid this issue by supporting the Cascade change relevant sphere alternative. When you impose referential ethics and choose the Cascade revision associated areas solution, therefore after that upgrade a major trick, accessibility immediately upgrades all areas that reference the principal secret.
You also have to delete a row and all relevant documents aˆ” by way of example, a Shipper record as well as associated instructions for the shipper. That is why, Access supporting the Cascade erase associated Records choice. When you enforce referential stability and choose the Cascade erase relevant reports check container, accessibility instantly deletes all documents that reference the principal trick when you remove the record which contains the principal key.
Change cascade revise and/or cascade erase on or off
Throughout the build tab, when you look at the Relationships team, mouse click All relations.
Note that concealed tables (tables for which the concealed check field within the desk’s attributes dialog container is selected) as well as their interactions won’t be found unless tv show Hidden items is chosen in Navigation Alternatives dialog package.
Click the union line for all the union you want to change. The connection range looks fuller if it is picked.
Double-click the connection range.
The change relations dialogue box appears.
Select the Enforce Referential ethics check box.
Pick either the Cascade posting associated industries or perhaps the Cascade erase associated information check package, or identify both.
Make further modifications toward commitment, immediately after which click okay.
Note: In the event the major secret was an AutoNumber industry, selecting the Cascade change relevant sphere check box may have no effects, because you cannot change the importance in an AutoNumber industry.
Erase a desk union
Important: as soon as you remove a commitment, you also eliminate referential integrity support for the connection, when it is allowed. Consequently, accessibility won’t immediately avoid the development of orphan information in the “many” part of a relationship.
To eliminate a table partnership, you should delete the partnership line in Relationships windows. Situation the cursor so that it points to the connection range, then click on the line. The connection line appears heavier when it’s picked. Because of the commitment range picked, push REMOVE.
On the Database gear case, during the connections class, mouse click affairs.
On build loss, within the interactions cluster, simply click All Relationships.
All tables with interactions is presented, showing commitment contours. Keep in mind that hidden tables (dining tables for which the Hidden check box for the desk’s qualities dialogue package is chosen) in addition to their relations will not be revealed unless program concealed stuff is chosen in Navigation selection dialogue package.
Click on the partnership line your connection that you want to delete. The connection range appears thicker when it is selected.
Hit the ERASE key.
Access might highlight the content have you been sure you wish to once and for all delete the selected connection out of your database?. If this confirmation information seems, click certainly.
Note: If either associated with dining tables utilized in the table union come into utilize aˆ” possibly by another individual or techniques, or even in an unbarred database object, such as an application aˆ” you’ll not have the ability to erase the relationship. You should shut any open items that employ these dining tables if your wanting to make an effort to remove the partnership.
