Print  |  Close

QL-800

FAQs & Troubleshooting

FAQs & Troubleshooting

How to create a barcode from two data fields (P-touch Editor 5.x for Windows)

To create a barcode from two data fields, do the following:

 

This example shows how to create a barcode from the "item number" and "number of pieces" fields in a database.

Database

 

  1. Start P-touch Editor and select the "Professional" mode.
    Step1

  2. Click [File] - [Database] - [Connect].
    Step2
     
  3. Click [Browse] in the [Open Database] window, select the database file, and click [Next.].
    Step3

  4. Select the sheet you want and click [Next].
    Step4

  5. Click the Database area (highlighted in red in the image below).
    Step5

  6. The [Database] menu appears. Click [Database] - [Connect Fields].
    Step6

  7. The [Define Joined Fields] window appears. Click [Add].
    Step7

  8. The [Add a Joined Field] window appears.
    From the [Fields] list, select and add the fields in the order you want.
    For this example, first select [item number] and click [Add], and then repeat this step for [number of pieces].
    Click [OK] and then [Close].
    Step8

  9. Click the label area (highlighted in red in the image below).
    Step9

  10. Click [Insert] - [Database Field].
    Step10

  11. The [Merge Field] window appears. Select [Bar Code] as the Merge Type.
    From the [Database Fields That Can Be Merged] drop-down list, select the fields you added in Step 8 (in this example, [item number] [number of pieces]), and then click [OK].
    Step11

  12. A preview of the barcode appears in the label area.
    Click the item you want to print in the database area. The preview changes to your desired barcode.
    You can now print your barcode.
    Step12
Print  |  Close