I have an assignment table (master table) and a review table (detail table).  The review table holds one or more records for each record in the assignment table.  I need a query to return the latest review for each record in the assignment table.  Could someone advise me on a query to do this.

The assignment table has the following fields: assignid, assign_date, manager, Projectid

The review table has the following fields: reviewid, assignid, review_date, progress_note

Thanks in advance.