I have two tables, one with a date, PK and a FK to the second table. I need to select the latest date and the two keys for every group of FK's. If my data is this:

Date         PK          FK
1/1/2001     1           1
1/5/2002     2           1
2/2/2001     3           1
6/6/2005     4           2
1/1/2005     5           2

Then I'd like my output to look like this:

Date         PK          FK
1/5/2002     2           1
6/6/2005     4           2

I'm having trouble coming up with a query to do this. Any ideas?

TIA,
~~Bonnie