AnsweredAssumed Answered

Replace Field with Value List

Question asked by TurtleKoala on Jun 23, 2011
Latest reply on Jun 23, 2011 by philmodjunk


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.