Software

Ask something
Discussion Locked

LOOKUP IN ACCESS 2000

0 helpful
2 replies

by nuinfluences

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is it posible to lookup data from one table and insert it in another

I have table 1 with a code no and description fields I want to type in the Code no into a column in table 2 and have it look for the corresponding description in table 1 and input this itself.

I have tried a lot of lookup combinations ala excel but cannot get this correct

2 replies

by c1980

Do you want to do this using a form, or inputing directly into a table in the database window?

The best would be to use a form for the input.

You could also do this with a query by entering only the Code numbers into the second table, and then use an update query to update the description fields.

Otherwise, building a form would do what you want.

This discussion is closed to new replies.