read value from field

[LeNoR]

Hello, guys!
I have one big problem! I am new in Access World. I define one Field in Table with 3 different Values form another Table. But now I dont know how to extract that values. Can somebody help?
Thanks

 

[plog]

I think I speak for everyone when I say, 'Huh?'

Can you elaborate, show the table structure of both tables and possibly some sample data from each?

 

[LeNoR]

Yes, my explanation is a little confusing...
With LOOKUP WIZARD I define one variable with values from another Table. That table has 3 columns.
How can I read those values separately?
EXAMPLE:
Field_A in TABLE_A with Lookup Wizard has values Text_1, Num_1, Num_2
In Form, I have one field with value from Field_A, Text_1. In another field in same form I need a value Num_2 from Field_A, Table_A.

 

[plog]

Still not getting it. Can you post specific data? Field_A in Table_A with value Text_1, just isn't helping. Present your data like this:

Table_A
Field_A, Field_B, Field_C
1, "John Smith", 12/8/2012
2, "David Jones", 1/1/2011

Table_B
Field_D, Field_E
1, "Accounting"
2, "Human Resources"
3, "Janitorial"

 

[RWR3]

Hi,
You have to make a Query that has the table with the three fields and the table with the lookup field. To do this you Create a form in Design view, then open both tables. Then drag the fields you want from both tables down to the bottom. If you add the lookup field to the bottom its value is the Primary keys value from the table with the three field (so don't use it). Drag down the three fields from the other table and they will be the values you want.

Hope this helps.