Try something like the following:

select main.*,max(weeks.field1) as maxweeks ;
   from main inner join weeks on weeks.main_fk = main.pk ;
   group by main.employee_last_name ;
   order by employee_last_name

This will create records with duplicate entries for the Main data associated with the Weeks data. VFP will then calculate the MAX() leaving only 1 record per employee in the result set.