The basic idea is to return the first item of every group of related items from a given table. So you need to determine which ones are first of a group, then get the entirety of those rows.
I'll give your construction a try, I'm not sure if VFP 9 will accept the implied grouping but its a good idea.
Sigfried Trent, aka FoxMan
(Working from his secret code cave, FoxMan battles the forces of darkness lead by the deranged and mysterious Bug Boy)