Print two fields from database based on data in first field Follow

0

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!

5 comments

0
Avatar
Xabier Clemente
Moderator
Comment actions Permalink

Hello Bob,

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
Avatar
Bob Osborne
Comment actions Permalink

Hi Xabier,

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?

thanks,

Bob

0
Avatar
Xabier Clemente
Moderator
Comment actions Permalink

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
Avatar
Bob Osborne
Comment actions Permalink

Xabier,

That got it!  Thanks for the help!!

Bob

0
Avatar
Xabier Clemente
Moderator
Comment actions Permalink

That's great news Bob!

Have a great weekend! :)

Please sign in to leave a comment.