I am new to this so please guide me if I may have missed standard practice in asking question.
I have two tables. These are used together and practically there is no use of them individually. I have attached sample structure in the images here.
First image contains the queries that will provide value of the field when executed. Second image contains the table that provides positional and format info which will be used when the label is printed.
In short, first table gets the value and second gives the info about where to put the value on page when printed.
PROBLEM: The first table has around 350 records. Meaning 350 different fields whose value will needed to be fetched every time someone hits "print".
Second table has over 100K records (350 fields x 300 different label templates). So there is a redundancy in second table. I am storing same type of info for same fields again and again for 300 times.
Is there any way I can avoid this? I am hesitant to create too many tables and I also want to avoid this type of redundancy.