If not a lookup table, a Select query using the DISTINCT predicate such as SELECT DISTINCT tblStores.Store FROM tblStores
Editing the table directly does not allow for validation of the data.
I might be all wet here, but couldn't a lookup field in a table be a form of validation if you set
Limit To List > yes; Allow Value List Edits > No and provide a combo as the lookup control on a query or list table?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.