Skip to main content

Search

Search

Multiple Records On A Single Label

Comments

5 comments

  • Avatar
    Ian Cummings
    Moderator

    BarTender doesn't  currently support multiple DB records per label.  This can normally be worked around most easily by controlling BarTender externally via automation and setting the data directly.  The use of an embedded VB script can be used to make it's own database connection and supply the record data to the appropriate data source.  Sorry, but I don't really have an example script to share with you. 

    0
  • Avatar
    Legacy Poster

    This may be of some use.  It is a little old, but I took the same path as Ian suggested and used VB to connect to the DB and get multiple child/detail records for the parent/header.  http://seagullscientific.invisionzone.com/index.php?/topic/79-populating-child-records-from-parent-db-record/

    0
  • Avatar
    Legacy Poster

    This looks like something that will solve an issue I have with the label I am currently constructing.  I am a bit confused as to where the script should reside and the naming of the other fields to which the data needs to go.  Does the script go into one of the objects on the label or should go in Docuemment Options? 

     

    Also, when I try setting another label object to a value retrieve in the script I get an error message.  Any ideas as to what I am not setting properly?

     

    Thanks!

    0
  • Avatar
    Domingo Rodriguez
    Moderator

    Please check the comment from Shane on 26 August at the below related forum topic:

    http://seagullscientific.invisionzone.com/index.php?/topic/73-designing-labels-with-1many-relationships/

     

    You should find there an answer to your questions.

     

    Besides this, in the past I developed a simple VB.NET example which shows how to externally implement a multiple records per label solution. I hope this helps:

    https://drive.google.com/file/d/0B33fAd6W79x8WmFwM0pra29BZWc/edit?usp=sharing

    0
  • Avatar
    Legacy Poster

    I did look at Shane's link prior to posting this question.  However, it is not clear as to where the scrip is to reside, at the object level or at the Document Options level.

    1

Please sign in to leave a comment.