Replace Field with Value List
Is there any way to replace field contents with a value list? Essentially, I have a table of purchases, and each purchse pertains to a client. Now I want to create a table of clients because there is certain client specific information that I want to put on each purchase record, but I would rather enter it once per client rather than once for each purchase. I plan on using the client name to link the two tables together. I realize that I would be better off using a numerical primary key such as a serial number for this purpose, but the client names are unique, and there is a very small chance that any of the names will change. It is a chance that I am willing to take. I also realize that I could perform a find for each client and do replace field contents on that found set, but I would prefer to have a new table so that I don't have to enter the data for each new purchase.