I'm trying to set up a label print layout to be printed in Avery 3 1/2" x 5" which is a 4 sheets labels. I have two tables: Products & Labels which they are connected by the ID's which is number ans set it to auto enter serial.

In my Products Table I have the Following fields

Field Name	Type
Material Name	Text
Material Lot No.	Number
Received Date	Date
Quantity Received	Number
Units	Text
Location	Text
No. of Container Product ID Match Field	Number Auto enter, Serial

In my Labels Table

Field Name Labels ID match Field Container Number

Type Auto enter, Serial Number

Can you please help me to set up my layout like the attached. I want that it will show the number of containers in ascending order. Like for example if I received 10 containers it will show to each label like ( Container 1 of 10 ; Container 2 of 10 ; Container 3 of 10..etc)

 

 

Thank you so much in advance.

Edited June 3, 201510 yr by Lola

On any layout you can display a field or just the text of a field in a text object. I would use the later for every field in the labels screen. You can do this by adding a text object, the then go to insert >> merge field. You can also merge "get" variables. So in the container text object it would read "container: <<container number>> of {{foundcount}}".

you can send me the file and I can show you what I mean if you need