Assistance With Dropdown List And Dependent Values
In BarTender 9.4 SR3, I have created a label with a dropdown list from which to choose an item number. The label also has to have an item description and upc code that corresponds to the item from the user's selection from the dropdown list. The item description and upc code are in the same SQL table as the item number.
I've been able to successfully create a VB Script to connect to the SQL database and load the item number list with the values from the SQL table. I need to have the item description and upc code that matches that item update their respective fields. I would also like to limit the dropdown list with a query and am a bit unsure of how I can achieve this. In SQL, there would be a where clause. In this case, I am not sure if it's possible to put that in.
strCon = "SELECT " & column1Name & "," &column2Name & "," &column3Name & "," &column4Name & " FROM " & Tablename & " ORDER BY "& column1Name
I am using the Prompt Design at print time to select the item from the dropdown list. I am asking for the user to enter the number of labels to print. The label has an item number, item description, and a upc code on it.
Thank you in advance.
-
bump.
0 -
To help formulate SQL you can use BarTender's built-in database connectivity from a test document, and then copy paste the SQL it generates under the "SQL" tab into your script.
It should be noted that there are no "OnChangeData" events in the prompt form, so if you're hoping that when you select value X in form control A that form control B will automatically update with value Y from a related field, unfortunately that won't happen. For this sort of functionality you'll need to build a front-end form application using something like VB.NET, in order to take in the data entry exactly as you want it, and then to control BarTender via automation to print labels.
We're interested in adding such functionality in a future release, but we don't have it now.
0
Please sign in to leave a comment.
Comments
2 comments