🚀 go-pugleaf

I'm trying to set up a filter for a grid using values from 3 comboboxes on a
form.  I have a dmd on the form with afper.rowser and afcert.rowset.  Basic
concept is to have the user establish values in the comboboxes and then, in
the onclick event of a pushbutton(??), have the results shown in the grid.
The comboboxes are linked to small tables containing values that are
selected when the user is entering data in another part of the app.

The fields from the comboboxes are as follows:
Service (in afper) - combobox1

Title (in afcert) - combobox2
Level (in afcert) - combobox3

So the user set values in the combobox(s), and clicks on the appropriate
pushbutton.  What I am struggling with is the filter statement (string?) for
the grid.  I've tried 'select * from "afper.dbf","afcert.dbf"
where ---&&this is where I get lost.  How do I correctly develop the filter
string from here?  Is my starting Select even correct?  Needless to say,
I've not gotten very far yet<g>.

  Am I even approaching this correctly??  I thought of a "filter by form"
but was trying to set up something that is user oriented.  Some of the folks
using this system need to be held by the hand, so I figured datalinking
entryfields and having the user type in the filter value was probably not a
good idea.

Any "hep" is _greatly appreciated.

John

--
Staub & Associates, Inc.
(850) 913-8488
http://www.staubassociates.com
Buy your books, etc. online at
http://www.staubassociates.com/bkstore.htm