2 Records/barcodes From Same Data Source Follow

0
Avatar
Legacy Poster

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!

3 comments

0
Avatar
Legacy Poster
Comment actions Permalink

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
Avatar
Legacy Poster
Comment actions Permalink

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
Avatar
Shotaro Ito
Comment actions Permalink

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.

Please sign in to leave a comment.