Pat,
Tables 2 and 3 are on the many side of a relationship with table 1 in this database, shown in the relationships window. In the query, I'm only using tables 2 and 3 and they are linked 1 to 1 via the key fields since they are identical. As a side note, table 2 had a duplicate set of indexes...