Sorry for the confusion.
96 pens each has a tx#. That number is either 1,2,3,4,5,6,7,8,9,10,11,or 12.
Below is the table. I want my master form to get the tx# from this table based upon the number I enter in my master form. The master form inturn updates my master table with that value. If...