I have two tables in Access with company data, like company name, address, contact, etc.
One of the tables has complete company names, like "Random Business Limited" or "Huge Corporation Plc", the second has only shorter names like "Random Business" or "Huge Corporation".
I wish to set up a...