Print More Than One Label Based On Query Results
[size="6"][/size][font="Tahoma"][/font]We are currently programming via an ODBC connection to pull a few basic pieces of information from our Database such as part #, qty, etc. We currently put in an order number and it pulls the 1st item in the list, so we have a one for one order/part ratio.
We need to be able to put in the order number that has say 10 parts listed on the order/pick/packing list and have it produce those same 10 parts as 10 individual labels. How can this ratio of 1 to 1 be changed to 1 to 10 based on a query to a database?
Any help is appreciated as this is causing issues with our customers. Thank you.
We need to be able to put in the order number that has say 10 parts listed on the order/pick/packing list and have it produce those same 10 parts as 10 individual labels. How can this ratio of 1 to 1 be changed to 1 to 10 based on a query to a database?
Any help is appreciated as this is causing issues with our customers. Thank you.
0
-
If the database query prompt is correctly build, it should give you the result which you want, which is 10 records / labels printed. In Bartender, by default, one record of your database (even if it results from a query prompt) means 1 label to be printed.
Did you also take a look yet at our training videos on how to select records at print time using BarTender?
http://www.bartenderbarcodesoftware.com/label-software/training-video-(selecting-records-from-a-database-at-print-time).aspx0 -
That is correct, I just need some assistance with the syntax to ensure the query is built correctly to pull more than one record set. I did try to look at the training video, but that link is broken. Thank you in advance for your assistance. 0 -
Awe, the training video helped immensly. Thank you, didn't even realize they were there. SO, I am able to print the records the way I want.
Just one more little question. I currently have it prompt for qty because sometimes our qty shipped is not equal to what was ordered. I can set this to prompt for each record, but the question is, is there a way to show the substring info (Part #) so they know what quantities they need to put in?
If that doesn't make sense, I apologize, but let me know and we'll take another stab at it. Thanks.0
Please sign in to leave a comment.
Comments
3 comments