Corresponding record

[Frank Dulk]

Hi,
I have a table with id, field1 and field2 I want to type the field1 and
automatically he to bring me the field2 of the same line.

example
1, 10, 50
2, 11, 51

I want to type the 10 and he return the 50, if I type the 11 he will return
the 51 and and so on

 

[John Vinson]

Hi,
I have a table with id, field1 and field2 I want to type the field1 and
automatically he to bring me the field2 of the same line.

example
1, 10, 50
2, 11, 51

I want to type the 10 and he return the 50, if I type the 11 he will return
the 51 and and so on

Create a Query based on the table. Select Field1 and Field2.

On the Criteria line under Field1 put

[Enter Field1] (in Portuguese of course <g>)

Open the Query; type the value of Field1; you'll see the corresponding
value of Field2 in the query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps