Darrel,
It was *the* solution. Made a parameterized view, added it to the DE, and requery it when the user skips to another record. Thanks for putting me on the right track.
>How about this ?
>
>CREATE SQL VIEW lvMyView AS SELECT ...
>
>Put the view in the dataenvironment and use the 6-Fields option in the combobox.
>
>
>Darrel