UPDATE Query in ADP

R

RAM

I need to update information in one table based on data in a second table. I
know how to perform this in an MDB but I'm migrating to an Access Project and
attaching to a SQL database. When I try to create the query in the ADP only
one table displays (the table to be updated) and I don't understand how to
set the criteria for the table with the data to send to the table to be
updated.

Thanks in advance,
 
Top