Hey,
I have a form with two subforms on it and they are linked together so that when someone clicks on a line item in the table, the other table automatically updates to show the notes pertaining to that line item. Table 1 has the following columns: Item ID, Nomenclature, Manager, and Status...