Multiple Records On A Single Label Follow

0
Avatar
Legacy Poster

Does anyone have a script that will insert multiple records onto a single label? I am looking to create a packing slip style label that would have header info and detail info. The issue I am running into is that I am only getting one detail record per label when I would like to have multiple records per label.

5 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

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
Comment actions Permalink

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
Comment actions Permalink

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
Comment actions Permalink

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

1
Avatar
Legacy Poster
Comment actions Permalink

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.

Please sign in to leave a comment.