Okay, I've got 2 tables:

Table A
CLASS TEMP_RANGE_MIN TEMP_RANGE_MAX
1 0 20
2 21 40
3 41 60


Table B
ITEM TEMP CLASS
Cow 18
Cat 30
Keyboard 55
Dog 21

-Both tables exist in the same Access97 database

In Table B, the user inputs ITEM and TEMP but not CLASS... When another button is clicked, the program has to refer to Table A and write the CLASS that each item belongs to in Table B.

Is this possible? How do I do this? Would really appreciate some assistance before I self-combust!