Skip to main content

Search

Search

Generating Multiple Labels Per Label, With Serialized Bar Codes

Comments

5 comments

  • Avatar
    Legacy Poster

    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
    Moderator

    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

    >>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
    Moderator

    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

    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.