how to make Value appear acording to conditions

[tarek_ta2ta2]

i really finished my Database

the result i have 5 Combo boxes

1- make
2- model
3- transmission
4- year

the user choose values from this combo boxes
EX. Toyota - corrola - Manual - 2005

so what i wanna do is make a button when the user push it after selecting all values compare this values to values stores in another table so if the value is matched make the last cell value appear ( which will be the price)

is it possible or i just dream.....

 

[neileg]

This is a technique known as cascading combo boxes. Do a search in these forums for plenty of advice. Not just a dream!