From: craig.futterman@nospam.comcast.net   
      
   The setup:   
   I have developed an anesthesia assessment form attached to our clinical   
   database. This form's data model has two tables in it. There are times when   
   these patients are repeat patients. I would like to be able to give the user   
   easy access to the previous assessments and even copy some of the data from   
   a previous encounter that the user will choose.   
   I don't want the current record to show up on the form showing the previous   
   records   
      
   The question:   
   Is it better to use setgenfilter and just filter for the patients medical   
   record number OR  have the form run a query and copy all the previous   
   records to a new set of tables and have them view the records in a new form   
   and do what they need to do?   
      
   I think the first one is the most elegant but I don't see a way to do   
   setgenfilter and NOT have the current record also viewed.   
      
   Thanks,   
      
   Craig Futterman   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)