Nancy
Thank you - I did catch the pre-snipped version of your message and I don't mind "Chapettes" contributing at all! :-) As for having the foil off the CPU - not sure I understand that.
Yes I'm working through suggestions and my ideas.
Terry
>Terry-
>
>>Thanks for the input, guys. I'm just formulating it in my head. Yes, there are indeed 3 tables with a ZONE field: ALLZONES, RZSTOP and the cursor I'm scanning, to wit:
>
>*snipped*
>
>>So I had decided to prefix the field but not sure how to do it. I've used a named expression to get the cursor so how can I use this in the expression:
>> lcSeekKey = thisform.cRoute + thisform.cGen + thisform.cDirectn ;
>> + "1 " + STR(
lcSetZoneCrs.ZONE, 4)
>>gives an error. How?
>
>
str(&lcSetZoneCrs.Zone,4)
>
>p.s. Better double check that you're scanning what you think you're scanning.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.