VLOOKUp

[azrak1201]

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]

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]

You need to manually select it from the combo unless you set the Default value.