Now that i have two datagrids i have to different table information showing one is the order table and the other is the customer table (off of the access database) my question is how do i link the information to the right customer.so when i scroll to the next customer the datagrid should also change shouldn't it? i don't know this is way different that access.
p.s
both of the tables (access) have ID's linked to one another in access.
lee123
Hi,
The way i m using to make a link b/w teachers name and thier monthly attendance in my database i have a seperate database for every teacher.
I have done suchthing.
At the back i have named the databases by teachers seril no or customer serial no.whenever the serial changes the database with named the serial number opened and shown in the grid.
You can say
If the serial no of customer is 1 then database no 1 opened to ADODC2
when 2 database no 2 opened to ADODC2
and so on.
**************
And the next type you have only one database
then its very easy use this code to choose the order associated with customer.
with respect to name
-
-
Dim cs As String
-
cs = txtCustomerName 'Must be from customer info database
-
-
ADODC2.Refresh
-
ADODC2.Recordset.Find "Name='" & cs & "'"
-
-
With respect to Serial No
-
-
ADODC2.Refresh
-
ADODC2.Recordset.Find "Sr = " & txtSR ' Must be from customer info
-
-
GOOD LUCK
ALI