Updating a table's yes/no field based on another table (1 Viewer)

Hi,

I'm new to Access so the question below might be better stated:

I'm trying to update the yes/no field from one table containing a list of members based on whether their last name appears on another table. If their name is in the other table then I want the cell corresponding to them to be checked and if not unchecked.

Is this possible?

Yes, make an update query,
Join the 2 tables on the like field, set any criteria,
Set field= true

If some of the rows might already be checked, you need to run an update query FIRST to clear the existing values and then run the query suggested by Ranman256.

However, as I hope you can see, storing a value (the checkbox) that can be calculated is dangerous. You should base any actions on a query that uses a Left Join. The Left Join will return all rows in the main table plus any matching rows in the second table. If the ID field of the second table is not null, the record is in both tables. If the ID is null, the record is only in the main table.

Ranman256 and Pat,

Your advice worked perfectly! Thank you for all the help.

Max