Dropdown based on SQL Query with answer from previous dropdown
Hi,
When I create a dropdown and set its "Linked Data Source" to a query prompt I get the record picker to display correctly.
But I want something a little bit more complex.
I have two questions. 2nd question is based on 1st question.
Ex.
Question 1 : Enter Product Number :
Product1
Product2
Product3
Question 2 : Enter Batch Number :
This dropdown must be a query to database based on productNumber selected at question 1.
How to do it ?
Is it using Named Data Sources, Global variables, Visual Basic Scripting ?
** I have already setup my 2 questions on 2 separate forms in sequencial order.
Thanks a lot.
-
There is no way currently to create a conditional data entry field based on the input from a previous field. You could either setup two database filters linked with an AND so that BarTender only displays records that match both criteria, or configure the first filter and then include a record picker on a Data Entry form so all the records that match the first criteria are displayed and you can pick the correct one from there
0 -
I don't think it could work.
Because I want the user to :
1. Select the product
2. Than Select the lotNumber based on the product
3. Finally Select the label language based on the product and lotNumber previously selected on first two questions
Is there a way to share variables ?
I'm trying to reproduce something I was able to do in Crystal Reports and JasperReports for years.Thanks a lot.
0 -
You could either give the 1st field a Name and link to that name for the subsequent fields or else set the Type to Object Value for the 2nd field and link to the object name of the source (good for GS1 data fields where they need to be YYMMDD in the barcode but can be shown differently in text fields)
0
Please sign in to leave a comment.
Comments
3 comments