Lookup Function in Access

Hi,

I have 2 tables in Access, "Table 1" and "Table 2". Boths tables have 2 fields, "SysID" and "Flex02".

How can I create a function similar to Excel where in "Table 1" I can lookup "SysID" from "Table 1" against "SysID" from "Table 2" and return the value of "Flex02" from "Table 2" into a new field in "Table 1".

Hi, just build a query that links the SYSid column to the other tables SYid column, and choose to diplay Sysid from any one of them and Flex02