Access Data Entry Question

[Guest]

Data entry question in Access:

Assume you have three columns: One, Two, and Three

When column One = A and Column Two = B, is it possible to auto populate
column Three with C?


My real life example of what I am trying to do is…
I enter grocery products into a database and then categorize them. So we
products that repeat themselves, like Lean Cuisine Frozen Single Serve
Entrees.

I first enter Lean Cuisine, and then Frozen, and then Frozen Single-Serve.
I’m would like to save a couple key strokes and have it auto populate the
last one or two fields. So every time I enter Lean Cuisine, it auto
populates …. Frozen…Frozen Single Serve Entrée.

Is this possible?

Thanks for your help in advance! Bonnie

 

[Guest]

Yes, you need a table listing all the valid combinations of product
categories. Then as information is entered you query this table finding the
count of matching items. Once the count reaches 1, you can auto-populate all
the remaining columns. E.g.
A B C
A B D
B C F
B D E
C C C

In the above example, if you enter A, B, you cannot autopolutate since there
is A B C and A B D.
If you enter B, C, you can autopoputate F since that is the only possibility.

You'll need some knowledge of VBA to program this.

-Dorian