Select record from Database at print time, filter database base on selection, print 2 different template design. Follow
I would like some help how to handle my problem.
We use Bartender 2016 automation and i would like the following template to setup but missing some understanding and can't find what i am looking for.
1st I have one Access database with 2 tables.
1 table will be the selection table for the part number selection.
The 2nd table is joined with the first table over an ID number. The second table will have all data for the labels and is filter by the ID number. Record are filtered and will have x labels to print when i select from the dropdown list the part number i would like to have the labels.
This i can setup for the first label design.
Now i have a 2nd design label that will have the same data source but only a summery page with the part number printed in the list. I can use the same function as above and work fine but i require to use a Page template so i can't use both (x single labels & summery page) in the same template design.
Page template is like this:
with the single record template like:
Now i would like to have both labels combined into 1 query at print time that would be used at a print station.
Basically operator run print station when print label select the part number and x single labels plus summery page are printed.
I do not know how to do this and if i need to setup a global database or the batch maker know that both will select the same part number with selecting at print time.
I also need to define a qty of the batch at print time as i would like to have it sorted in batch during print time.
I try to use a global data field but i am not able to link the query prompt and enter the selected part number from a dropdown list to this global data field.
Somehow i miss how this works.
Can somebody point me in the direction if this possible or what objects i need to use to make this possible.
Thank for anybody who is looking into this.
Please sign in to leave a comment.