Lookup problem

  • Thread starter Thread starter Black Hawk
  • Start date Start date
B

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
 
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.
 
Try this:

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