Populating a field based on another

M

Michael

Is there a way to search a field for keywords, and then
populate the new field based on that search?

I have sales that I want to categorize by product type.
I need a new field called "ProductType", and then
populated based on "ProductDescription".

For instance, if "ProductDescription" = Forks or Spoons,
the new field should automatically say "silverware". If
it was pots or pans, it should say "cookware".
 
S

Steve Schapel

Michael,

You need to add another table to your database which lists all the
Pruduct Descriptions which should be associated with each Product Type.
You might even already have such a table, as this would be handy as the
basis of a combobox for the entry of the ProductDescription for new
records. On the face of what you have told us so far, it is probably not
a good idea at all to have a ProductType field in your existing table at
all, it should be looked up in the lookup table which I am suggesting.
 
Top