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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto populate a field based on value of other fields 1
Entering info into one field & having the description auto fill. 3
unfamiliar with how Excel handles data - question 0
Using Macros Set Value to fill in a field on a form 3
populate form field from table 1
auto populate a field based on other fields 3
Form Not Populating Consistently! 0
Populate a value in a form based on another value 1

Top