Discover community or industries you want in order to describe because the an important secret
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. (more…)