VLOOKUp (1 Viewer)

azrak1201

New member
Local time
Today, 10:28
Joined
May 8, 2018
Messages
1
Hi guys, can i do a process in access 2010 similar to the vlookup in excel? not in forms but across fields. say for example i have a field in [MineExUG] that has [Eqpt_Numb], and that field is connected to a value in the [LookUpTable] table with the matching [Eqpt_Numb] in the lookup table. i know how to do an update query to fill in the values but what i want to do is to do it automatically when a new value comes on for the new row. i hope my question is straightforward and i hope hope for a reply. thank you guys!
 

NauticalGent

Ignore List Poster Boy
Local time
Today, 13:28
Joined
Apr 27, 2015
Messages
6,286
If I understand you correctly, you want to populate fields in one table that already exist in another (lookup) table if the match a common value.

Assuming that is correct, this is not how data is stored in a properly structured Database.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:28
Joined
May 7, 2009
Messages
19,169
You need to manually select it from the combo unless you set the Default value.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:28
Joined
Feb 19, 2002
Messages
42,971
There is normally no need to store the lookup value. Whenever you need to see it, base your form or report on a query that joins the main table to the lookup table. Use a left join if the lookup field is optional rather than required.
 

Users who are viewing this thread

Top Bottom