To select that field, click the row selector into the need field. To pick multiple industries, hold down this new Ctrl key, and then click the row selector per job.
If you prefer your order of your fields within the a simultaneous-community number one the answer to change from your order of those sphere regarding the desk, click Indexes into toolbar to exhibit the fresh Spiders dialogue container, after which reorder industry labels for the index entitled PrimaryKey.
Referential stability
Referential ethics was a network regarding legislation you to Availableness uses in order to ensure that matchmaking between information in the relevant tables is actually good, and that you do not affect delete otherwise change related studies. You could place referential stability when every following the requirements try true:
- Brand new coordinating industry regarding number one desk try an initial trick or enjoys a different sort of directory.
- The newest associated sphere have the same investigation particular. There are two exclusions. An enthusiastic AutoNumber profession should be pertaining to lots job you to have a great FieldSize assets form out of Long Integer, and you can a keen AutoNumber industry who has got a beneficial FieldSize possessions function from Duplication ID might be connected with lots job that a great FieldSize possessions mode off Duplication ID.
- Each other dining tables fall under the same Availableness databases. Should your tables try connected dining tables, they have to be dining tables during the Availability format, and you need open the fresh database in which he or she is stored to put referential integrity. Referential integrity cannot be implemented having connected tables of database into the most other forms.
- You simply cannot go into a respect regarding the international trick world of the fresh new relevant dining table that does not occur however key of one’s number 1 table. Although not, you could potentially get into an effective Null well worth regarding the international trick. So it determine the facts are not related. Instance, you cannot features an order which is allotted to a buyers who not are present. not, you can get your order that’s allotted to no one by typing an effective Null value in the CustomerID community.
- You simply cannot remove a record of an initial dining table if the matching ideas exists inside the an associated desk. Instance, you can not remove a worker record from the “Employees” desk when the you can find commands allotted to the worker throughout the “Orders” desk.
- You cannot change a primary secret value from the priple, you cannot https://datingranking.net/tr/tagged-inceleme/ alter a keen employee’s ID in the “Employees” dining table if the you’ll find commands allotted to you to staff regarding the “Orders” desk.
Flowing condition and deletes
Getting matchmaking in which referential stability are enforced, you could indicate if you need Access to immediately cascade update otherwise cascade delete relevant records. If you put these solutions, delete and update surgery that would usually be prevented of the referential integrity regulations are permitted. Once you delete details or transform top secret opinions within the an effective primary desk, Availability helps to make the requisite change so you’re able to relevant dining tables to preserve referential ethics.
If you click to determine the Cascade Improve Relevant Areas view package after you define a romance, any moment you replace the no. 1 key out of a record in the main desk, Microsoft Availableness automatically updates the key key to the new worth in every associated suggestions. Including, for folks who change a customer’s ID on “Customers” dining table, this new CustomerID occupation about “Orders” table is actually automatically upgraded for every single certainly one of that owner’s orders therefore, the matchmaking is not damaged. Accessibility cascades updates instead of displaying any content.
In case your primary type in the key dining table try an AutoNumber occupation, choosing the Cascade Posting Related Fields see field has no perception as you dont change the value inside an enthusiastic AutoNumber career.
