Does anyone know how I can select the max date, based on a foreign key in a 2nd table, and update the date field in the first table with that value?

Here's what I have now

1st Table Fields (One record per Stock_No)

Stock_NO

Last_Update



2nd table (Multiple Records per Stock_NO)

Stock_No

Update_Date



I basically want to grab the most recent Update_Date per Stock_No, and update the 1st table with that value.

Can anyone offer any ideas? I've never done an update like this. Thanks