From: rednoise+news@REMOVETHIScomcast.net   
      
   On 04 Jun 2007, Michael Kennedy  wrote in   
   comp.databases.paradox:   
      
   > If you're building a query manually, then:   
   >    - put the cursor in the "source" field   
   >    - hit F5, and type a simple name for that field, just a few   
   >    letters   
   > or digits, say we call the field "x".   
   >    - move the cursor to the "destination" field   
   >    - type the following:   
   >        changeto x   
   >    - BUT, just before typing the "x", hit F5.   
   >   
   > In the "changeto", you can build fairly complex formulae, if   
   > needed...   
   >   
   > If you're building a query in PAL, you can save the above query   
   > (using QuerySave) and use it "as is", or you can build the   
   > equivalent commands. In the latter case, where the "x" appears,   
   > just precede them with an underscore.   
      
   Thank you very much. Now that I know what to look for, I find the   
   answer in the book, buried in the section about multi-table queries.   
   Obviously not where I would have expected to find it!   
      
   I think it's a little odd to have to use these arbitrary tokens to   
   refer to fields rather than the field names themselves. Maybe it will   
   make more sense after I use the method for a while.   
      
   Anyway, I knew it had to be simple, as it's a basic function that any   
   DBMS would have. Thanks for pointing me in the right direction.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)