Generating Multiple Labels Per Label, With Serialized Bar Codes S’abonner

0
Avatar
Legacy Poster

I need to generate two barcodes per label using an Excel sheet. The end results should look like the image attached

 

 

I need to make sure to serialize them so I can spare myself hours of typing. I have chosen Excel to make this easier. My Data tables look like the following (only did 20 lines of 75)

 

Sheet1                  Sheet2
83A J 01C1	     	83A J 01C2
83A J 01D1	     	83A J 01D2
83A J 01E1	     	83A J 01E2
83A J 02C1	     	83A J 02C2
83A J 02D1	     	83A J 02D2
83A J 02E1	     	83A J 02E2
83A J 03C1	     	83A J 03C2
83A J 03D1	     	83A J 03D2
83A J 03E1	     	83A J 03E2
83A J 04C1	     	83A J 04C2
83A J 04D1	     	83A J 04D2
83A J 04E1	     	83A J 04E2
83A J 05C1	     	83A J 05C2
83A J 05D1	     	83A J 05D2
83A J 05E1	     	83A J 05E2
83A J 06C1	     	83A J 06C2
83A J 06D1	     	83A J 06D2
83A J 06E1	     	83A J 06E2
83A J 07C1	     	83A J 07C2
83A J 07D1	     	83A J 07D2

I need the tables to be read for the top barcode from Sheet1, and the bottom from Sheet2.

 

I can not figure out how to make both of these work. I need to add another thirty sheets to finish all the labels. Any suggestions on how the Joins should be setup to make it work? Everything I try seems to tell me that its not valid "Row 1 does not have a table referenced by another row" I am not sure what this means.

5 commentaires

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Condensing it into one table, as it was not needed to be in two sheets, I found it works much better, and will do its job, no need to join anything.

0
Avatar
Fernando Ramos Miracle
Modérateur
Actions pour les commentaires Permalien

Indeed introducing all your fields on one single sheet will solve your issue.

 

In any case, if you wanted to join several database tables, you would need to use a common field (not necessarily identical) so BarTender knows the relation between the different records on each table. The simplest solution is to add a field to each database table with the numeric value of each record's position (1 for the first record, 2 for the second record...) and use that field to join the different database tables.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

>>you would need to use a common field (not necessarily identical) so BarTender knows the relation between the different records on each table.

 

Since you're speaking of JOINs, out of curiosity, how would he join the tables if he had 2 key columns?

Our version of Bartender complains that we specified 2 keys in the same table, as if that's not a perfectly normal table relationship.

0
Avatar
Fernando Ramos Miracle
Modérateur
Actions pour les commentaires Permalien

In their case, as they wish the first record from sheet 1 to concur with the last record from sheet 2 (and I guess that the second record of sheet 1 with the second last of sheet 2 and so on) they would need to add a field on sheet 1 with values [1,2,3...], while on sheet 2 they would need to add a field with the opposite values [21,20,19...]. Then create a Join using these two new fields with the operator "equal [=]".

 

This will basically unify the two sheets into a single database with the records of sheet 2 inverted.

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Fernando, I wasn't very clear with my question, and it *was* a tangent, only related to this thread in that you were speaking of SQL JOINs. I told another poster that the bartender GUI query tool was not capable of multi-key joins, and he would have to use a custom query. Since this thread was basically over, and you were talking about SQL JOINs, I wanted to determine if I was correct in what I told the other poster. For example, table A has key 1 & key 2, and table B has key 1 & key 2....

 

Thanks-

Vous devez vous connecter pour laisser un commentaire.