ZDM
|
| Posted: 03/01/2002, 3:39 PM |
|
as I can do searching for on some tables inn DB together
|
|
|
 |
Sam M
|
| Posted: 03/01/2002, 8:29 PM |
|
Now,
I know I could catch flack about this but I would do it in Access rather than codecharge. Here is what I would do.
1. open access
2. create two tables with the following fields
a. field1
b. field2
make two tables with these fields, make sure they are identicle
2. go to queries
3. create a new query
4. select SQL view
5. cut and paste this code
SELECT Table1.*, Table2.*
FROM Table1 INNER JOIN Table2 ON Table1.field1 = Table2.field1;
This will create a query that can be accessed like a virtual table.
You can use it to display information and search. Access Queries are your friend, play with them as much as possible.
Cheers.
Sam
|
|
|
|
ZDM
|
| Posted: 03/02/2002, 3:02 PM |
|
many, many thanks
you are friend !!!
|
|
|
|
Sam M
|
| Posted: 03/03/2002, 7:54 PM |
|
Glad I could help bro.
|
|
|
|
|
