To choose one career, click on the line selector on the wanted community. To pick several fields, hold-down the brand new Ctrl trick, and click this new row selector for each and every career.
If you would like the transaction of industries into the a parallel-industry first the answer to change from your order of them fields about table, mouse click Indexes on toolbar to show the Spiders dialog box, following reorder industry labels into list titled PrimaryKey.
Referential ethics
Referential stability try a network of regulations that Accessibility uses in order to make sure that dating ranging from ideas into the relevant tables was good, and that you don’t happen to remove or transform relevant data. You could potentially lay referential integrity whenever most of the after the criteria try true:
- The brand new complimentary job throughout the primary table was an initial key otherwise possess a special directory.
- The fresh new relevant fields have a similar studies type. There’s two exclusions. An enthusiastic AutoNumber occupation are connected with lots community you to definitely enjoys an effective FieldSize possessions means out-of Much time Integer, and you may a keen AutoNumber occupation who has a FieldSize possessions setting off Replication ID are going to be about a number profession that has an excellent FieldSize assets mode out-of Replication ID.
- Each other dining tables get into the same Access database. If for example the dining tables try connected tables, they must be dining tables in Availableness style, therefore need discover the newest database where he’s held to put referential ethics. Referential stability can not be enforced getting linked dining tables off databases from inside the other forms.
- You can not get into an admiration regarding overseas trick field of the fresh new associated table that doesn’t can be found in the main secret of the number 1 dining table. Yet not, you could potentially enter a beneficial Null well worth regarding overseas secret. This determine the records is actually not related. Such as for example, you can’t has an order that is allotted to a customers who does perhaps not are present. Although not, you could have your order which is assigned to no body because of the entering a good Null worth regarding the CustomerID profession.
- You cannot remove accurate documentation of a first table in the event that matching details occur inside the an associated desk. Such as, you cannot delete a member of staff checklist about “Employees” table in the event the you’ll find requests allotted to the personnel in the “Orders” table.
- You can’t transform an initial key really worth throughout the priple, you cannot change an enthusiastic employee’s ID on the “Employees” desk when the you can find sales assigned to one staff member regarding the “Orders” table.
Flowing reputation and you can deletes
To have relationship where referential integrity was enforced, you can specify if you need Access to immediately cascade posting otherwise cascade delete related suggestions. For folks who set this type of choice, remove and update functions who constantly be prevented by the referential stability regulations try allowed. When you delete facts or change first trick viewpoints when you look at the an excellent number 1 dining table, Accessibility helps make the needed alter to help you relevant dining tables to preserve referential integrity.
For people who click to find the Cascade Modify Associated Sphere glance at package after you explain a romance, any time that you change the top key regarding accurate documentation in the primary dining table, Microsoft Supply automatically position the primary key to the new worth in every related facts. Instance, for folks who change a customer’s ID throughout the “Customers” dining table, the newest CustomerID community on “Orders” dining table is automatically current for every single one of that owner’s purchases therefore the dating is not broken. Supply cascades reputation as opposed to showing people content.
If https://datingranking.net/cs/brazilcupid-recenze/ for example the primary type in the main desk are an AutoNumber occupation, selecting the Cascade Inform Associated Industries look at package has no perception since you try not to alter the really worth inside a keen AutoNumber industry.