Records

A record represents information about an individual item. In an Address Book table, it would be a person. In a diary, it might be one day's entry.

The Record Summary window contains a listing of all of the records in the table you chose to open. From the Record Summary window you can click on any Attachment fields to launch their respective files, and you can see the data in your Short Text fields, and the beginning of the data in your Long Text fields. In order to add a new record, just click the Add New button. To view or edit an existing record, either highlight the record and click the Open button, or double-click the desired record.

Whether adding or editing a record, the next screen you see will be the Record Detail window. This window displays all the fields you specified when creating your Table Definition. Small Text fields are rendered as text boxes, Large Text fields are rendered as multi-line text boxes, and Checkbox fields are rendered as - you guessed it - checkboxes. If you specified a Date field in your table definition, it will be rendered as a text box filled with a date, with a button next to it. Clicking that button causes a calendar to be displayed, from which you can pick a date.

For each attachment field you specified, you will see a Browse button, a Link button, and a clickable link. Clicking the Browse button displays a file dialog box which allows you to choose a file from your hard drive to attach to the record. It could be any file; photo, video, document, whatever. If you click the Link button instead, you can specify a web site to attach to the record. (If you want to attach both a document and a link, you will need to create two Attachment fields in your table definition.) Once you've attached a link or a file to the record, you can click on the link to launch the file or web page directly from the Record Detail window. (You can also launch an attachment by clicking on it in the Record Summary window.)