Is this possible ?

[uday777]

Hello Friends,
i am new to this forum and access also. i have a problem,
i have 2 tables table1 and table 2

table1 is like this and already having records as shown below
[age] ___[term] ___[value]
15 _______11 _____32.6
15 _______12_____ 31.6
16 _______11_____ 25.3
16 _______12_____ 22.5
17 _______11 ____ 26.3

and other table2 is same with fields [age1][term1][value1] with NO records in it i want to do that if i entering value in table2 age andterm i want value
automatically in that field i;e; if [age]=[age1]&[term]=[term1] then i want automatic display of [valu]=[value1] means if i am enteringin table2 [age1]=15 and [term1]=11 i want automatic
display and store of 32.6 in [value1] automatically. and i want to display same procedure in form also.. plz help me for this problem.

u can see sample file here

http://www.sendmefile.com/supercool/00311165
password: jmpcuday


http://www.sendmefile.com/supercool/00311165


http://www.sendmefile.com/supercool/00311165