Field data between tables

[Guest]

Sorry for the rookie question.

I have two already populated tables of information. Table 1 (main table) has
about 20,000 records. Table 2 (reference table) has about 50,000 records.

Let me refer to fields in Table 1 as X1, Y1 and in Table 2 as X2, Y2.

All records in Table 1 have an X1 value. Most of these X1 values have a
corresponding X2 value in Table 2. I need to create a new field in Table 1
such that:

For any given record, if X1 = X2, then Y2 is automatically transferred to
Table 1 so that Y2 = Y1. The new field is Y1.

Thanks for your help.

 

[Al Camp]

I would think an Update query would do the trick.
Relate tables by X1 to X2, (Show all X1 and only those X2 where equal) and
then Update Y2 with the corresponding Y1 value.
hth
Al Camp