I've done that too! DISTINCT checks for distinct values of all the fields chosen - and in this case the PK is by definition unique so you'll get a record for each PK.

Try:

Select location, pk ;
   where !empty(location)

Good Luck
Barbara


>Barbara,
>Thank you.
>Just one more question and I'm out of your hair and off to work.
>
>When I tried that before with:
>select distinct location, pk
>I got both loaction and pk, many blank locations.
>
>Is that the wrong use of Dist.
>
>Peter
>
>>Slowly the light dawns. You'd like the combos to reset to the SAME record if a user makes a choice in any of them. So if he chooses "Thanks" in combo1 you want him to immediately see "Gracias" "Arigato" and "Merci" in the other 3? You'll need 2 columns in each combo. The DisplayValue will be the text, the Value will be the PK of the record. Then in the InteractiveChange of each combo you set the value of the others to the PK. If the PK isn't found (because a blank value wasn't included in the list), you may have to add code to blank the record. I haven't tested it.