>>The composite key is your way out, or using cursors (with so-called safe select - and if the grids are editable, some code for write-back into the source tables), or parametrized views. And the composite key will work, unless you have Set Exact On - i.e. seek("008") will find a record whose county+desc="008Knockshire"
>
>Yeah, I guess. Not editable grids anyway so simpler. Cheers mate.
And, completely unrelated, in our transcription, there's Jorkšir, Berkšir, Lankašir ("šir" being read as "sh-ih-r", like "shear" with a short i). Nokšir is vernacular expression for the potty. Official expression would be "noćni sud" - literally, "night vessel", but by quirk of language, it also means "night court" (of law, not of a king). So "Knockshire" is an attempt to reexport a word which sounds like it's borrowed, although it's not.