Names matching

An anonymous writer wrote: >We have a problem of matching names (esp. Company names) from one table to >another. >One of the table is actually a consignee database. [stuff deleted] I have had a similar problem dozens of times and have always found the most effective solution to be as follows: 1. Establish a master table containing only the permitted names. If necessary, in the interest of speedy data entry you can assign each one a code. 2. In your form only allow values in the main table that already exist in the master table. ** Opinions expressed are my own and not necessarily those of my employer ========================================================================= Barry Toomey Phone +353-1-2822333 AT&T Network Systems Ireland Fax +353-1-2822864 Corke Abbey Avenue, email: bt@irl3b2c.att.com Bray, uunet: att!irl3b2c!bt Co. Dublin Ireland =========================================================================