Print More Than One Label Based On Query Results 关注

0
Avatar
Legacy Poster

[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.

3 评论

0
Avatar
Domingo Rodriguez
版主
评论操作 固定链接

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).aspx
0
Avatar
Legacy Poster
评论操作 固定链接

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
Avatar
Legacy Poster
评论操作 固定链接

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.

请先登录再写评论。