Populating a field based on another

  • Thread starter Thread starter Michael
  • Start date Start date
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".
 
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.
 
My product descriptions are irregular, but usually contain a keywork. For example

parchment papa
paper, cardboar
notebook pape
paper rol
crate pape
etc, etc, etc.

How can I tag the records as "paper". From what I know about lookup tables, the fields must match perfectly. I can't possibly list all the permutations in a lookup table.
 
Back
Top