My program has a listbox with t1.a populated on it. When the user clicks on an "a value," it would search the database and populate the textboxes which are supposedly connected to the fields (distributed to the 4 tables).
My concern is: is it possible to connect to all of these tables and populate my vb6 text boxes from them for viewing of records? I also need to be able to update the records.
Would this query work?
Expand|Select|Wrap|Line Numbers
- strSearch=lstNames.list(lstNames.listindex)
- SELECT * FROM t1, t2, t3, t4 WHERE t1.a >= " & strSearch