Views:

Product: CODESOFT, LABELVIEW

Version: All versions

 

This article goes over the steps for creating a picklist that is based off of another picklist (Double/Triple...).

NOTE: If you are unfamiliar with creating a pick-list that pulls from a database, please review this article HERE.

1.  Review the table below.

NOTE: From the database, there are 3 different fields that we would like the rest of the data to populate off of. Those fields are SKU, LOT, and LINE. We need to create a picklist for all 3.

After going through the article for creating a picklist, create a Table Lookup for the picklist. To eliminate duplicates, we will need to edit the query in SQL mode. With the field that we are selecting data from, type in the word "DISTINCT". This will remove duplicates from the column.


2. Create a Table Lookup for each field you would like to have on the label.

NOTE: For more information on this process, refer to our training guide here.

Each Table Lookup will be dependent on the key field (column name) and the data source value (Picklists).

3. Review the following image.

In the image, we are returning the "COLOR" field. "COLOR" is dependent on the values SKU, LOT, and LINE. Those are all values of our picklists, which we notate in the key value (data source). Each Table Lookup that have these "Sheet1$:" have a similar process.

We can now pull each Table lookup onto the label template and test.

3. Open the Form, right click the Form Tab, and select new vertical tab group so we can see the label design and the Pick-lists side-by-side.

NOTE: You will see the information change for each Pick-list value and correspond the database records above.

          

 

 

Keywords: Picklist, database picklist, double picklist, link picklists, dependent