Generating Multiple Labels Per Label, With Serialized Bar Codes
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.
-
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 -
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 -
>>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 -
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 -
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-
0
Please sign in to leave a comment.
Comments
5 comments