Autofill field with data from other table

[Gregory23]

Hi ,

Is there a way to autofill field in form based on another field's value with data from other table

Example

Table 1

ID	Material	Description
001	10000
002	20000

Table 2

MAterial	Description
10000	Example123
20000	Example234

Would like description in Table1 to fill out automatically (with Example 123) if Material 10000 is entered into the form.

With other words to fetch Description from Table2 into Table1 if a certain material number is entered

Thank you



G

[ranman256]

An update query.
join the 2 tables on material