georgex5 wrote:1. The Fields are created as one line but expand automatically when you type into them. I would like to create fields that have more than one line all the time, even if the field is empty.
2. I would like to set up the data base so that every Record takes up a whole page in the document. As it is now, records can appear part on one page and the rest on the following page. This makes printing individual records difficult.
3. I would also like to have the record number be part of the record.
4. Also, I would like to move records around like you can text in AW6.
I'll number these in the same order as asked, but would advise doing #2 first, as this will give you more space on the layout for the others. For the first two of these, you will need to be in Layout mode (press shift-command-L, or go Layout > Layout) to make the changes. To view the effects, return to Browse mode (shift-command-B or go Layout > Browse). You'll probably find it convenient to do #3 in Layout as well, as this will give you the opportunity to place the Record No. field where you want it on the layout.
1. Layout puts you into the Draw environment, and a Layout may be edited in the same manner as a Draw document. Unless you have added other objects, the Layout will contain two types of Frames: Text frames, containing the Fieldname in boldface type, and Field frames, also containing the Fieldname, but in normal weight type. AppleWorks places a pair of frames (in the frontmost Layout—others are unchanged) for each Field you create or Insert into the Layout, and enters the Fieldname into the Text frame. The two frames are independent of each other—you may edit the contents of the text frame or even delete the frame without affecting the Field frame.
To resize a frame, select the frame, then drag the handle on one of the corners until the frame is the size you want. To move the frame, click on any part of the frame except a handle and drag the frame to the new location.
In Browse, Field frames will display at the size you set, but will expand (if necessary) to show all their contents when you place the insertion point in the frame.
2. The Body boundary, a grey line running across the page, determines the bottom boundary of a record. Drag it to the bottom of the page to make each record take a whole page.
3. A Serial number type field will number each record as it is created. Existing records will be numbered in the order they are displayed when the Serial Number field is created. By default, the serial number will start at 1 and increment by 1. This can be changed using the Option button when creating the field.
Note that you can also record the Date, Time, or User logged on when the record was created or was last modified using a Record info type field. For existing records, this type of field will enter the information current at the time of the field's creation, not that current when the record was created.
4. You can reorder records by selecting one (click on the Record, but outside any Field to select and highlight the whole record), then dragging it to it's new position in the list. With each record taking up a full page after the layout change in #2 above, you may find this easier to do in List (shift-command-I or go Layout > List) where each record takes a single line. To select a record in List, click in the small empty cell at the left end of the line.
You can also Sort (command-J) records on one or more fields.
Regards,
Barry