I am creating a search option for my application...
I've constructed a form that allows the user to search the address book by Company Name, First/Last Name, or by Phone #. The results will be displayed in the address book form - either by list box or directly into the forms items... eg. labels,textboxes, etc.

Now obviously I can create one connection to the database based on my specific criteria and view the results in a listbox. I'd like to attempt to (using vb)... use the different connections based on the results of the search option... refer to psydo code below

assume:
-comboBox1 is Company Name
-comboBox2 is First/Last Name
-comboBox3 is Phone #
-Listbox1 DataConnection1, DataConnection2, DataConnection3

If comboBox1.indexChanged then
use DataConnection1 show results in Listbox1
end if

If comboBox2.indexChanged then
use DataConnection2 show results in Listbox1
end if

If comboBox2.indexChanged then
use DataConnection3 show results in Listbox1
end if

*****************************
Looking at that general logic I am struggling with how to call the different connections and how to show the results in Listbox 1.

Any suggestions would be appreciated... Thanks in advance.


LNickol
GIS Assistant
Gwa' sala - Nakwaxda Nation

Halito LNickol,

Have you tried querying your database(s) giving a result set, and then ordering the set by the appropriate field:

ie:

Select fields from database1
Join on Database2 fields
Join on database3 fields
giving resultset.

Good luck

Tom

Hi again,

use the Order By clause to order the result set.

Sorry my description maybe a little confusing...

I have 1 listbox. Based on the results of a search the listbox will display the data.
rather assume the following
Search By Options...
-comboBox1 is Company Name
-comboBox2 is First/Last Name
-comboBox3 is Phone #

Display Results...
-Listbox1 DataConnection1(Query - Company Name)
-Listbox1 DataConnection2(Query - First/Last Name)
-Listbox1 DataConnection3(Query - Phone #'s)

I hope that is a bit clearer! Thanks for taking the time, I appreciate it.



LNickol
GIS Assistant
Gwa' sala - Nakwaxda Nation