Working with Related Data Fields

In a related data field, you can store information about records that is relevant to the data source but isn’t linked to the data source. This information is stored in a separate section of the related data field called notes.

For example, in a Recipes library that has a related data field linked to the Ingredients library, you could store information such as the required amount of each ingredient in a recipe in the notes section of the Ingredients related data field. In other fields in the notes section, you could add details about how to prepare the ingredient or the name of the store where you purchased it. The information in the note fields is not stored in the Ingredients library.

You can create, view, and edit calculations in the notes section. For more information see ”Creating Calculation Fields” on page 87.

To display the notes section:

Position your cursor on the right edge of a related data field. When the cursor changes to , drag it to the left. You see the notes section with the first notes column (named New Column) created for you. Type a new name for the column, then press Return or Tab.

 

To add a column in the notes section:

Click  near the right edge of a column header, choose Add Column Before or Add Column After. Type a new name for the column, then press Return or Tab.

 

To change the name of a column in the notes section:

Do one of these:

•	Double-click the column name, type a new name, then press Return or Tab.

•	Click  near the right edge of a column header and choose Edit Column Name, then change the column name in the dialog. There, you can also change whether you want Bento to complete text automatically as you type in the field.

 

To change a column from one data type to another:

1	Click  near the right edge of a column header.

2	Choose Change To, then select a data type from the list.

Note  Not all data types can be changed. For more information, see ”Changing an Existing Field from One Type to Another” on page 96.

 

To show or hide the summary row:

Do one of these:

•	Choose View > Show Summary Row or Hide Summary Row.

•

Click  .

For more information about the summary row, see ”Summarizing Column Data” on page 77.

 

To delete a column in the notes section:

Click   near the right edge of a column header, then choose Delete Column.

 

To sort records in related data fields:

Click the pop-up menu in a column header, then choose Sort Ascending or Sort Descending.

 

To display related data records in a grid format:

Click to display the records in a grid.

 

To set labels for grid view items:

1	In grid view, click .

2	Click the Title pop-up menu, then choose up to two fields.

Each field’s data is displayed as a label for the grid items.

If you don’t want a label to be displayed, choose the dash symbol for the field.

 

Home > Using Fields > Working with Related Data Fields