r /> Figure 15: Template for CD or DVD case label with borders showing

2. To pull the data from your database, press F4 or choose View → Data Sources. Expand the database you want to use and select the table or query to use.

Figure 16: Selecting the query or table to do labels for

3. Click on the name of the field (not the data) that you want to use and drag it into the label. When you move your mouse over the field, you'll see the full path of the database, table, and field. Drag in all the fields that you want to use.

Figure 17: Dragging in the fields to print on the labels

4. At this point, most of the choices are up to you. Add any other text, like labels for the title, actors, etc. You can put in graphics, do colorful formatting; anything you want. Use table formatting tools to align the text at the top or bottom, or just press Return a few times to get it where you want it. Add shading to the table or to the background of the document to get the color you want. Do everything in the first label to the second label, as well: the same formatting, etc.

Figure 18: Formatting the fields in the labels

5. Copy the fields from the first label to the second.

6. You now need to insert the trigger that will make the next record in the database print—otherwise the next movie's information won't print until the next page.

a) In the second label area, click to the left of the first field, in this case Movie.

Figure 19: Preparing to insert an extra logic field

b) Choose Insert → Fields → Other, Database tab, select the Next Record field, select the database and table you're using, and click