Get the field or fields you want to help you define while the the main trick

Get the field or fields you want to help you define while the the main trick

To choose you to career, click on the line selector on wanted field. To choose several fields, hold-down the new Ctrl trick, and then click the new row selector each profession.

If you like the order of your own areas when you look at the a parallel-field no. 1 key to vary from your order of these industries on table, mouse click Spiders toward toolbar to display the fresh new Indexes dialog container, right after which reorder the field labels into directory called PrimaryKey.

Referential stability

Referential ethics was a network from laws and regulations one to Accessibility uses to help you make sure that matchmaking ranging from ideas in relevant tables is actually good, and that you don’t accidentally delete or transform relevant studies. You might set referential integrity when most of the adopting the standards was true:

  • The newest coordinating occupation on primary desk are a first key otherwise enjoys another list.
  • New relevant sphere have a similar studies variety of. There’s two conditions. An AutoNumber field can be associated with several career one enjoys a FieldSize property means from A lot of time Integer, and you will an enthusiastic AutoNumber field having an excellent FieldSize property form off Replication ID is going to be about a variety community that has a beneficial FieldSize possessions setting out-of Duplication ID.
  • Both tables belong to a comparable Availableness database. If your tables is connected dining tables, they have to be dining tables when you look at the Availableness structure, and you also must discover the fresh database where they are held setting referential ethics. Referential stability can’t be enforced getting connected dining tables off databases inside other forms.
  • You simply can’t get into a regard from the international secret world of the new relevant table that will not can be found however key of your primary desk. not, you could potentially enter an effective Null value on the foreign trick. So it specifies your suggestions are unrelated. Particularly, you can’t have your order that is allotted to a buyers that would perhaps not exists. However, you will get your order that is allotted to not one person from the entering an excellent Null worth throughout the CustomerID industry.
  • You can’t delete an archive out of a first desk in the event that coordinating info exist inside the an associated table. Such, you can’t erase a worker list on “Employees” dining table if the you will find orders allotted to the latest staff throughout the “Orders” dining table.
  • You simply can’t change an initial secret value about priple, you simply cannot alter an enthusiastic employee’s ID regarding the “Employees” desk in the event the there are orders allotted to one to staff regarding the “Orders” www.datingranking.net/tr/jeevansathi-inceleme/ desk.

Cascading position and you can deletes

To have relationship where referential ethics try implemented, you could identify whether you prefer Accessibility immediately cascade change or cascade erase associated records. If you lay such choice, delete boost surgery that would always be prevented from the referential integrity laws is allowed. Once you erase information or alter number 1 secret beliefs within the a beneficial no. 1 desk, Accessibility makes the needed alter so you can relevant dining tables to preserve referential stability.

If you mouse click to select the Cascade Revision Relevant Fields take a look at box when you explain a love, any moment which you change the number 1 key from a record in the primary dining table, Microsoft Availability immediately updates the primary key to brand new well worth throughout related details. Including, for many who changes a customer’s ID regarding the “Customers” dining table, the brand new CustomerID industry from the “Orders” table is immediately current for each and every among that owner’s commands therefore, the relationship is not busted. Availability cascades position instead exhibiting any content.

In the event the number one type in the primary dining table is actually a keen AutoNumber field, deciding on the Cascade Upgrade Relevant Sphere glance at package does not have any impression since you don’t alter the really worth in a keen AutoNumber occupation.

Leave a Reply

Your email address will not be published. Required fields are marked *