How to use multiple data tables on one label

Choose one reliable key that connects the tables, then test for missing, duplicate and one-to-many records.

What this page helps you do

Choose one reliable key that connects the tables, then test for missing, duplicate and one-to-many records.

Checks and steps

1. Identify the common business key, such as order, item, batch or serial number.
2. Write down which table owns each field and whether the relation is one-to-one or one-to-many.
3. Join or relate the tables using a controlled query or approved view.
4. Test one known record before adding all fields to the template.
5. Stop printing if the key returns no row or multiple unexpected rows.
6. Verify that each selected label record produces the intended single output.

Scope and verification