From: InabónYunes@Naboria.com   
      
   For the past 5 years I've been entering data using Pdx9.   
   My data is almost ready to be publish but I need a little help here.  I want   
   to accompany it with an application where users can do intelligent searches   
   in the database.   
   The information includes wildlife species and I users to be able to enter a   
   criteria (10 total) where an undelying table updates according to the   
   entries made.   
   For example, a person saw a bird and only got to see the color of its legs,   
   bill and eyes.   
   How do I make a form where a person enters the color of eyes he/she saw and   
   the table is filtered for only those species that have black eyes, for   
   example.  Then when the same user enters the color of its legs, the table   
   updates to only those species that have black eyes and yellow legs, if that   
   is the color entered.  Again, when the person enters the color of its bill,   
   it only sees in the table the species that meet all the three criteria.   
   I was working with variables for the field and using queries to display the   
   result on the canDepart method but everytime I run a query and use the   
   table, it erases the index keys, actually, no record is erased it just   
   doesn't have the index keys anymore.  The result is a non indexed answer   
   table.   
      
   If any of you can help me and direct me in the right direction, I think I   
   can do this.   
      
   Thanks!   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)