I have one Access database. I am going to use Visual Basic to display the information in Access database. I can use FlexGrid and Data control to display the table stored in Access. Below is illustration of my table in Access or table already in VB
id contents Field1 Field2 Field3
1 C1 A1 B1 D1
2 C2 A2 B2 D2
3 C3 A1 B2 D1
4 C4 A3 B1 D3
5 C5 A2 B3 D2
6 C6 A3 B3 D3
7 C7 A1 B2 D4
I want to do the following tasks:
Step1: select criteria = A1 in Field1 then display the table, so the table should be like this:
id contents Field1 Field2 Field3
1 C1 A1 B1 D1
3 C3 A1 B2 D1
7 C7 A1 B2 D4
Then select criteria = B2 in Field2 based on Step 1, then the result should be like this:
id contents Field1 Field2 Field3
3 C3 A1 B2 D1
7 C7 A1 B2 D4
Of course the criteria can be chosen randomly.
Does anyone know how to realize this goal?
Thank you very much for any help!
Chuan Wang
Royal Institute of Technology
Stockholm, Sweden
Homepage:
id contents Field1 Field2 Field3
1 C1 A1 B1 D1
2 C2 A2 B2 D2
3 C3 A1 B2 D1
4 C4 A3 B1 D3
5 C5 A2 B3 D2
6 C6 A3 B3 D3
7 C7 A1 B2 D4
I want to do the following tasks:
Step1: select criteria = A1 in Field1 then display the table, so the table should be like this:
id contents Field1 Field2 Field3
1 C1 A1 B1 D1
3 C3 A1 B2 D1
7 C7 A1 B2 D4
Then select criteria = B2 in Field2 based on Step 1, then the result should be like this:
id contents Field1 Field2 Field3
3 C3 A1 B2 D1
7 C7 A1 B2 D4
Of course the criteria can be chosen randomly.
Does anyone know how to realize this goal?
Thank you very much for any help!
Chuan Wang
Royal Institute of Technology
Stockholm, Sweden
Homepage: