set default value of field the value of other table field value

Yero

New member
Local time
Today, 11:05
Joined
Sep 11, 2011
Messages
2
Hi
I have a little problem with defination of default value
I have two tables "Arcive" and "Input" Archive have the following fields F1 and F2
Input have val5 and val7

here is table Input
val7 val5
CI/003137 , AAA
CI/003138 , BBB
CI/003139 , CCC
CI/003143 , DDD
CI/003145 , EEE
CI/003148 , FFF
CI/003128 , JJJ
CI/003131 , HHH
CI/003132

And here is table Archive
F1 F2
CI/003137 , AAA
CI/003138 , BBB
CI/003139 , CCC
CI/003143 , DDD
CI/003145 , EEE
CI/003148 , FFF
CI/003128 , JJJ
CI/003131 , HHH
CI/003132 , MMM

I don't use forms. Archive and Input have relationship Archive.F1=input.val7
The values F1 F2 and val7 inserted into tables manualy through access datasheet .
I need that when I insert new values the val5 takes the value from Archive.F2 field
automatic.
How can I do it?
In example I insert last record in Archive F1=CI/003132 F2=MMM
Input.val7=CI/003132 as I said I need that Input.val5 get it's value from Archive.F2
In this case it must be MMM

Please Help
Best Regards
 
You can't do that from tables directly. You would need to use forms to make it work.
 

Users who are viewing this thread

Back
Top Bottom