After starting Bartender you will need to add the CompuPlants Gold database. To do so go to "Database Setup" under the File menu. Click "Next" and on the next screen select "ODBC Data Source". On the next screen there should be a list of ODBC compatible databases. There should be an entry "CompuPlants Gold DB". Select that and go to the next screen.

You should see a list of tables on the left. To get the information we need add the tables "prdtl1" and "plants".

Since we have more than 1 table we need to join them together. All we need to do is provide the fields in the two tables that match. In this case that would be "pltno". So in "Left Field" and "Right Field" select "pltno". Click "Finish" to exit and then "Ok" to exit the next screen.

Now that we have added the database we can proceed with designing the label. First create a new text field in the upper left corner of the label. The go to its properties by right clicking on it and selecting "properties" or double clicking on it.

First off change the source from "Screen Data" to "Database". Then set the "Use Field" to "prdtl1.prdperno" (the catalog code). Press Ok to continue.

Using the same method listed above I added the text for "plants.pltnme" (the plant name). I also added a UPC symbol with "prdtl1.upc_code" as the field.

However, the UPC requires extra consideration. If you try printing one out it will only include 5 digits and won't include your company's UPC code. To fix this we will have to enter that part manually. To do so go to the UPC properties and select "More Options". Then go to the validation tab.

First set "Allowable Characters" to "Set by Input Mask" and then change the input mask to "12345600000;0;_" where "123456" would be your company's UPC code. Additionally you should also change the Barcode type to "UPC-A" on the main properties screen for the barcode under the "Bar Code" tab.

And we're finished. When you go to print it should print out one label for each of your products. You may wish to save this label as it will be used in the next example.

Back to tutorials index