I have a report that has 10 fields with data. Lets call them T1 through T10. Each field needs a label. Currently the labels are entered as text objects which requires them to be modified manualy in the .rpt file. The .rpt file looks something like this in the Details section:
label1 T1 label6 T6
label2 T2 label7 T7
label3 T3 label8 T8
label4 T4 label9 T9
label6 T5 label10 T10
What I would like to do is get the label data from an seperate table in the MDB. In other words there are lots for records with data for T1 through T10 and the table with the label data has 10 records
How do I do this?
I tried doing it with an unbound table but every time I try CR complains "Your current link configuration contains multiple starting points" and links the table anyway.
Is there a way to do this with an array?