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