To select you to definitely community, click the row selector towards the wanted industry. To select several industries, hold down the newest Ctrl secret, and click the fresh row selector per occupation.

If you prefer your order of your own sphere within the a parallel-career number one key to change from the order ones sphere on table, click Indexes on toolbar to show the new Indexes dialogue field, immediately after which reorder the field names for the list named PrimaryKey.

Referential ethics

Referential ethics is a system regarding legislation you to definitely Access uses so you’re able to make sure that dating ranging from facts in the relevant tables try good, and that you don’t affect erase or transform relevant investigation. You could potentially set referential integrity when the adopting the requirements try true:

• This new complimentary field regarding number 1 dining table are an initial trick otherwise has a different sort of index.
• The relevant fields have a similar study type. There are two main exceptions. An enthusiastic AutoNumber field is going to be pertaining to a number career you to definitely keeps a beneficial FieldSize possessions mode off A lot of time Integer, and you will a keen AutoNumber community that a FieldSize assets form away from Replication ID are going to be linked to several community who has got a good FieldSize assets function out of Replication ID.
• Both tables fall under a similar Accessibility databases. In case your tables is actually connected dining tables, they must be tables from inside the Availability structure, therefore need certainly to discover brand new database in which they are held to create referential ethics. Referential stability cannot be implemented for connected dining tables regarding database into the other formats.

• You simply cannot go into a respect in the overseas key arena of the relevant desk that doesn’t exist in the main key of one’s primary table. Yet not, you could enter good Null well worth throughout the foreign secret. Which specifies your details was not related. Such as, you can not enjoys your order that’s allotted to a buyers who would perhaps not exist. not, you will get an order which is allotted to no-one of the typing a beneficial Null well worth throughout the CustomerID field.
• You cannot erase a record out-of a primary dining table in the event the matching suggestions are present in a related desk. Particularly, you simply can’t erase an employee record regarding the “Employees” desk when the you will find instructions assigned to the latest staff regarding “Orders” table.
• You cannot alter an initial secret worthy of from the priple, you can not change an enthusiastic employee’s ID on the “Employees” dining table if the discover purchases assigned to you to definitely staff member from the “Orders” table.

Flowing updates and you will deletes

To possess matchmaking where referential stability is actually implemented, you could potentially specify whether you would like Use of automatically cascade modify or cascade delete associated information. If you lay these selection, delete and update surgery who does always be avoided from the referential integrity legislation is actually permitted. After you erase information or change number 1 trick opinions for the good top desk, Supply helps to make the needed changes so you can associated tables in preserving referential integrity.

For individuals who mouse click to find the Cascade Improve Relevant Fields view package after you describe a romance, anytime which you replace the primary secret regarding a record however table, Microsoft biker planet Accessibility immediately position the primary the answer to the latest well worth throughout related details. Particularly, for those who alter a consumer’s ID about “Customers” table, new CustomerID industry in the “Orders” table are automatically up-to-date for every single among one to customer’s commands therefore the relationship isn’t busted. Accessibility cascades reputation in place of exhibiting one content.

Whether your number 1 type in the primary table are an enthusiastic AutoNumber job, choosing the Cascade Revision Relevant Areas check box has no effect as you usually do not alter the really worth into the a keen AutoNumber industry.