Need to cross reference multiple part numbers on the same shipping label.

Bconrad1

• October 03, 2024 17:16

I need to cross reference up to six part numbers from the database on a shipping label. This is easy to set it up to do one but the sql integration seems to be too basic. If I run the same query on all of the barcodes I get one query box and all of them have the same information. When I set up multiple queries with multiple connections it wouldn't work. What is the work around for this. I can't be the only one who has tried to do this. Manually selecting the part numbers is not an option. 

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • October 04, 2024 08:15

  I am guessing this is linked to your similar query here:

  https://support.seagullscientific.com/hc/en-us/community/posts/216574487-How-To-Query-Sql-To-More-Than-1-Record-Into-Bartender?page=1#community_comment_26824358278807

  One alternate method could be to deal with all the record selection etc in your SQL program and output all the required data in a flat text file with the data from the records all as one string with a text field on the label linked to each of these fields    

  0

Please sign in to leave a comment.