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!