Fields

[defragment]

Hi. I need your help. I have 2 fields in access table. In one field i fill numbers eg (1,2,3,4,5) drop down list. In the second field I need to fill another data. When I chose one of the numbers from Field 1, I want automatically fill the second field with appropriate data.

1 = 24857
2 = 24869
3 = 24899
4 = 24944
5 = 24994
6 = 24903
7 = 15480
8 = 15164
9 = 15482
10 = 15479
11 = 15468
12 = 15476
13 = 15489
14 = 15494
15 = 7524
16 = 7537
17 = 7523
18 = 7544
19 = 7533
20 = 7536
21 = 7539
22 = 7534

 

[pbaldy]

Is this what you're trying to do?

http://www.baldyweb.com/Autofill.htm

 

[JLCantara]

Create a table that will hold the 1...22 corresponding value. From that table, create a combo with 2 col.: 1) 1...22, 2) corr. number. In the AfterUpdate event of this combo fetch col(1) value and store it in the appropriate field.