2 Records/barcodes From Same Data Source

Legacy Poster

• August 28, 2014 19:52

BT v.10

 

I am attempting to create a label with 2 UPC codes that are different records from the same data source.

 

I have user prompt for part number and from that, the query pulls out 2 records based on an ID field (ID 0 and ID 2).  My first UPC code is fine as it's reading the first record from the query - what's the best way to call out the second record (ID 2) so the second UPC code is unique and not duplicating the first UPC?

 

Thank you much!

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • August 28, 2014 20:25

  That didn't take long to figure out - :)

   

  Added a second connection to the same database, updated query in first connection to only grab ID 0, created query in second connection to grab ID 2 and then created an inner-join based on the part number between both connections.

   

  Prompted just once for part number and the barcodes are unique as per their data points.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • September 09, 2014 19:24

  Hi Nebie ..  I have a similar situation with you .. but  I need to print several records from one data source  in one label ...  (  it would be a LABEL  for identifying  its components )     

   

  Do you know how to I could do that ?

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • September 10, 2014 03:19

  Do you know how to I could do that ?

  You could show a example of how you want - database table and layout. However I recommend to contact support.

  0

Please sign in to leave a comment.