Print two fields from database based on data in first field
I have a small database with 3 fields: Class, Volts, Max Use. I need to choose Class from a dropdown box and print the corresponding records in Volts and Max Use on the label. So, for example,
Class = 0
Volts = 20000
Max = 1500
How do I tie the records together so that when I choose Class 0 from the dropdown, the proper volts and max will print?
Thanks in advance!
Welcome to the BarTender Community Forums!
I believe the simplest solution would be setting up a record picker in the Forms tab, this way you could see and choose the Class field even if the label itself it's not populated by this field. Please, review the following video about Configuring the Record Picker on your form.
I hope you find this article helpful, and please let us know if there is anything else we can help you with. :)0
The class field has two values so far, 00 and 0. They are in the records that way in the database, but on the record picker they both show as 0. Is there a way to get the 00 to show as 00?
Hi again Bob,
That could be caused by the Class field being set to "Number" instead of text. Could you access the Database Connection menu and under the Fields tab check if this is the case?
If it's not "Text", then we will need to double-click on Class' type and select "Text":
Then click on OK and it should work, as it would reference the field as text, so all of it should show.
I hope this works!0
That got it! Thanks for the help!!
That's great news Bob!
Have a great weekend! :)0