Retrieve data from different data sources conditionally

RMA AY

• January 25, 2023 02:16

Hello,
What I want to do is,
There are 2 list boxes. The 1st list box belongs to the companies. The 2nd list box is about the products of the companies.

If I select the 1st company from the list box, only the products of that company are listed, if I choose the 2nd company, only the products of the 2nd company are listed. how should I do.

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • January 25, 2023 11:13

  That is not possible just as two separate list boxes but you could achieve this if the item data was held in the same database, something as simple as

  Comp,ProdCode
  ABC Ltd,1111
  ABC Ltd,2222
  ABC Ltd,3333
  XYZ Ltd,2222
  XYZ Ltd,3333
  XYZ Ltd,4444

  would suffice. 

  In your label you would need to link it to the database and then add a filter (query) so that at print time the Company Name is selected. Once you have linked your label fields to the appropriate fields in the database you could then configure a Data Entry Form that has a text box linked to the Filter and adds a Record Picker table to choose the product from and so you could end up with something like this:

  

  0

Please sign in to leave a comment.