Hi,
First let me say that I did not create this database but rather inherited from someone else.
I have two tables, "tblProductCurrent" & "tblProducts" which store information about our products and their policy numbers. Both tables have the same fields, "PolicyNum", "ProductName"...