Stan Makrinos
February 20th, 1999, 04:28 PM
1. I used MS Access to create two tables(table1 and table2). They share a common field but are not linked.
2. In VB6 I created an environment1.command1 that connects to table1 and a command2 that connects to table2.
3. I then linked those tables with the common field(within vb2). In this one-to-many relationship table1 was the parent and table2 was the child.
4. I then used one datagrid to display a list of last names from table1 and a second datagrid to display a list of transactions for each of those names.
--------------------------------------------------------------------------
THE PROBLEM: I then added fields on the form that I linked to command2.[a field]
If I use the second datagrid to move from record to record, this movement does not update the contents of those fields. HOW can i have them updated?
YOUR HELP WILL BE GREATELY APPRECIATED!!!
SM
2. In VB6 I created an environment1.command1 that connects to table1 and a command2 that connects to table2.
3. I then linked those tables with the common field(within vb2). In this one-to-many relationship table1 was the parent and table2 was the child.
4. I then used one datagrid to display a list of last names from table1 and a second datagrid to display a list of transactions for each of those names.
--------------------------------------------------------------------------
THE PROBLEM: I then added fields on the form that I linked to command2.[a field]
If I use the second datagrid to move from record to record, this movement does not update the contents of those fields. HOW can i have them updated?
YOUR HELP WILL BE GREATELY APPRECIATED!!!
SM