To choose that community, click on the row selector on the wanted community. To choose several areas, hold down the fresh new Ctrl trick, and click new row selector for every field.
If you like the order of sphere within the a multiple-profession first the answer to differ from the transaction of them sphere regarding the desk, click Indexes for the toolbar to show the fresh new Spiders dialogue box, and then reorder the field names towards directory entitled PrimaryKey.
Referential ethics
Referential integrity try a system away from laws you to Availableness spends so you can guarantee that dating ranging from ideas inside the associated tables is actually good, and that you do not accidentally erase or changes related data. You can set referential integrity whenever the after the standards are true:
- The coordinating occupation on the number 1 table try a primary key or features a unique index.
- New relevant areas have a similar studies types of. There’s two exclusions. An enthusiastic AutoNumber occupation should be related to a number job that provides a great FieldSize property form away from A lot of time Integer, and you will an AutoNumber profession that has a FieldSize possessions mode from Replication ID is regarding lots industry who’s a good FieldSize property means off Replication ID.
- Both dining tables fall under a similar Access database. In case your tables are connected dining tables, they have to be dining tables inside Accessibility structure, while must discover the brand new databases in which he or she is kept setting referential stability. Referential stability can not be enforced having connected tables off database in almost every other formats.
- You simply can’t enter into a respect in the international secret arena of this new relevant dining table that does not can be found in the main key of your number one desk. not, you might enter a great Null really worth throughout the international trick. This determine that the ideas is actually not related. Such as for instance, you can not provides an order which is allotted to a buyers who would not exists. Yet not, it’s possible to have your order that’s assigned to nobody from the typing a good Null worth on the CustomerID industry.
- You simply can’t remove a record out-of an initial table if coordinating ideas exists inside the an associated desk. Such as for example, you simply cannot remove adultspace an employee number regarding “Employees” dining table if you will find instructions allotted to the new worker about “Orders” desk.
- You can’t transform an initial key really worth on the priple, you simply can’t change a keen employee’s ID about “Employees” table if you can find instructions assigned to one to personnel regarding “Orders” desk.
Flowing position and you may deletes
To have relationships in which referential integrity is enforced, you can indicate if or not you would like Usage of automatically cascade inform otherwise cascade erase related ideas. For many who lay this type of selection, erase and update businesses who does constantly be avoided because of the referential integrity regulations was let. After you remove facts or transform number 1 key thinking when you look at the good number one dining table, Access helps make the necessary alter so you can associated dining tables to preserve referential integrity.
For many who simply click to search for the Cascade Modify Relevant Industries consider container after you establish a love, when which you replace the number 1 secret away from an archive in the main desk, Microsoft Availableness immediately position the primary the answer to the latest worth in most associated information. Like, for many who changes a customer’s ID on “Customers” table, new CustomerID job on “Orders” desk was automatically upgraded for every among one to owner’s requests so the matchmaking is not broken. Availableness cascades condition as opposed to showing any content.
When your first input an important dining table was an AutoNumber field, choosing the Cascade Modify Related Sphere examine container does not have any impact since you you should never replace the worthy of for the a keen AutoNumber job.