Finding values in 2 tables?

[quipy]

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!

[honeybee]

You can open a recordset to Table A. When the user clicks that other button you can run code to find out where the Temp fits, and retrieve the corresponding class value from the recordset.

Alternatively once the user clicks the button, you can run an SQL query that picks up only the suitable record from Table A based on the TEMP value, and returns its Class in a recordset. Use it in Table B.

.