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!