Need to create dropdown list in data entry form from separate database than named data source
We have a web frontend that we use for 99% of our labels. Initial data is collected from entry fields on the frontend: Country of Origin and Part Number. The Country of Origin is a dropdown list and the Part Number is a free form field, but is validated against the database table that feeds the label information. When the Part Number field is entered, a validation is done against the database table and pulls back the label format used for the specific part number. The Country of Origin, Part Number and the label format used, are passed as parameters to a Web Service Integration created on the Bartender application server, which then opens the label specified and passes all variables in, with the Part Number being the only parameter feeding the query prompt that populates the rest of the info on the label. This works fine if we're using the web frontend, but 1% of the time we need to use Print Portal and
For that 1% where we use the Print Portal, we need a dropdown list for the Country of Origin, but I'm not sure how to populate the dropdown because there is no relationship between the named data source used for the label and the data in the CountryOfOrigin table, so no opportunity to create a join. I'm guessing that I will need to do this in vb scripting on a Data Entry Form associated with each label, just no idea where to start.
-
Could you just add it as Dropdown list Data Entry form option and make it the users choice?
0 -
Well, we could, but this needs to be available for thousands of labels, and if we needed to add or remove countries, it would be terrible to try and update. We already have the information in a database table, so we had hoped to utilize it so we can add or delete once and everything is good to go.
0 -
The list can be contained in an external file
0
Please sign in to leave a comment.
Comments
3 comments