Lookup problem

[Black Hawk]

Hi there,
Im not a professional user of Access. Im using Microsoft Access 2003. I

have a table without any primary key. The thing I want to do is use
Field1 in Table1 to get the matching data into Field2(Table1) from
Table2. Table2 has Field1 as well as Field2. So like I'll enter data
into Field1(Table1), it will find matching text in Field1(Table2) and
get the data of Field2(Table2) into Field2(Table1), same row. If I use
a query for this, it doesnt allow me to edit anything. I hope I didnt
make it so complicated.


Regards,
A R Afridi

 

[Jeff Boyce]

You'll not get the most out of Access if you design your database/table
structure this way. If the data is already stored in table2, and if you've
already "pointed" to that date by using a key in table1, then you don't need
to (redundantly) store the looked-up value from table2 back into table1.
But that's only in regard to storing data.

To display data, use forms. You can use a query that retrieves the
looked-up value from table2, given the key from table1, and build a form
that displays what your query retrieves.

 

[OfficeDev18 via AccessMonster.com]

Try this:

UPDATE Table1 INNER JOIN Table2 ON Table1.Field1= Table2.Field1 SET Table1.
Field2= Table2.Field2;

 

[Black Hawk]

Thanks all .. I'll try this and let you know