i have an access db with identical fields (name, address, etc). it's all text data type. there is one table for each letter of the alphabet with each group of names in it. there is an automatic id ...

Learn how to add and remove Primary Keys from an Access database table. The primary key's purpose is to promptly associate data from multiple tables and combine that data.