> ...SELECT DISTINCT yourtable.yourfield FROM yourtable INTO yourwhatever should give you just the unique vales for the field in question, no? Do you also need the entire row?

Yeah, basically. I had already figured out how to eliminate the duplicates to generate a unique key. I was hoping I could use that somehow to produce entire rows.

Specifically, I've got unique part numbers and I want to build a table of the initiating work order for each part (the one-to-many relationship is from part number to work order number).

I can write a little scan loop that could build such a table from the key built by the SELECT DISTINCT you suggest above....I was just wondering if there was a way to do what I want with just SELECTS...I've played around a little with JOINS, but to no avail..no matter what type of JOIN I use, I keep getting a result set that is the size of the work order table.