Using Queries to fill in a field??

[TastyOs]

Hey guys, I'm new to the forum. I have a question and I'm not sure the best way too go about it. Pretty much I have 2 tables...

Table 1



a x
a x
a x
a x
b y
b y
b y
b y

Table 2
a x
b y

In table 1 there's additional fields that make each record unique, but as you can see, the first two fields in Table 1 have a lot of repetition. Table 2 is completely unique. Is there a good way to take info from field 1 of table 1, look at table 2, see where field 1 of table 1 is identical to field 1 of table 2, and take the data from field 2 of table 2 and put it into field 2 of table 1? I don't if I'm describing the situation well, but any help would be appreciated!

Thanks!

[ssanfu]

Welcome to the forum!

You are pretty vague..... but there are several ways to proceed.

If this is a one time event, use an update query, something like

UPDATE table1 SET table1.field2 = table2.field2
WHERE table2.field1=field1.field1;

If you are entering data in a form and there are combo boxes/list boxes, use the after update event with some VBA code to update table1.field 2.
If the control is a text box, the after update event might work for you.
I would use a PK/Fk relationship and not store duplicate data.