I have 2 tables that have a common field(purchase order number). The fields in each table are formatted exactly the same (standard text field). When I view one table in datasheet view, I can pull down the filter and it will list all the different values that I can check or uncheck. In the other table, when I pull down the filter, it does not show any of the existing values. I must manually enter any value I am looking for.
Does anyone know why one table would show existing values and the other not?
Thank you,