Using data sheets to add or edit links

Your database designer can set up data sheets to use instead of the standard forms for adding, editing, and deleting data. Data sheets are designed especially for your work, and show the fields that you need, arranged in groupings. Depending on the data sheet, you might be able to use it to enter data for related entities and links.

Depending on the type of data sheet, you can enter details of a main entity, add links and possibly create new link end entities. The fields in the lower part can be a mixture of the link fields and the entity fields.

To use a data sheet to create links between new or existing entities; Select New > Datasheet > datasheet name. To review or edit the links between entities: select the entity, right-click and from the menu, select Show With > datasheet name.

Note: Your database designer might decide to make the data sheet the default method for entering record data for a particular entity. When you want to show records you can choose whether to show the details with a data sheet. To make this choice, select one of the Show With options on the menu.

When you use the Show With and New With options on the menu, you are shown the name of the data sheet in the lower half of the menu. Depending on how the database designer has named a data sheet, it may have the same name as the main entity type. Executing