Get the community or fields you want in order…
To pick one field, click the row selector on desired occupation. To select several areas, hold down the latest Ctrl key, and then click the new row selector for each and every occupation.
If you prefer the transaction of one’s industries during the a parallel-career primary key to differ from the order of these sphere from the dining table, click Indexes on toolbar to display the latest Indexes dialogue container, immediately after which reorder industry brands to the directory named PrimaryKey.
Referential integrity
Referential ethics try a network off rules you to Availableness uses to help you ensure that matchmaking anywhere between info during the associated tables is actually valid, and you don’t eventually delete or changes relevant research. You can place referential ethics when all of the pursuing the conditions is true:
- The new complimentary occupation throughout the primary dining table try an initial secret or possess a new index.
- The associated areas have the same data method of. There have been two exclusions. An AutoNumber occupation will be pertaining to lots field you to definitely has an excellent FieldSize possessions mode of Enough time Integer, and you will an enthusiastic AutoNumber field who’s a FieldSize assets setting out of Replication ID would be associated with lots job who’s a good FieldSize assets means away from Replication ID.
- Each other tables fall under the same Access databases. If your dining tables is actually linked tables, they have to be dining tables into the Availability structure, while need certainly to open the latest databases where he or she is kept to create referential ethics. Referential integrity can not be enforced to have connected tables of database during the almost every other formats.
- You cannot enter into an esteem regarding the foreign key arena of the latest associated desk that will not exists in the main key of the first dining table. Leer más «Get the community or fields you want in order to explain just like the the primary trick»