|
|
 |
 |
|
| |
How do I create a Table Lookup in CODESOFT 7 or higher? |
|
| |
- Connect to your database using ODBC or OLE DB. In this example, we will use OLE DB. After you connect to the database, do not bring it into the label format.
- Create a form variable. Double-click on the variable's name, Var0 in this example, enter a meaningful prompt and set the minimum length. (This will be your key field variable. Change the name to a meaningful term if you like.)
- Right-click on form and select form customization. Click on the pull down arrow for Display form when printing and select “For each label”, or “For each series”. Click OK.
- Create a table lookup variable. Note: you will need to create a table lookup variable for each “result field” that you want to appear on the label.
- Edit the setting for each of your table lookup variables. These pertain to the database you added in step 1.
Select type: type of database
Select data source: database name
Select table: table within the database
Select result field: is the output field
- Click on Append Row. Click in the key field box that appears to get the pull down menu and select the key field in your database. Select the key value field for the pull down menu and select the key value, which is the form variable you created earlier. Click OK.
Key Field: this is the field that will be used to lookup the data.
Key Value: this is the Variable (Var0) (that will be keyed in at print time)
- Place your table lookup field on the label. This will be your result field.
- At print time, you will be prompted to enter the variable data and click OK.
- Repeat steps 4-7 for each result field you wish to include on your label.
|
|
|
|
