>That aside, i have the child table set up with a child key and it works, sorta, for some reason its only seeing the first record that it comes by. After that first record it sees in the child, it refuses to update the form i have it in. Anyone know any reasons why it would update the fields from the parent table, but not the child?
Are you saying you are updating data in the parent table that also exists in the child table? What fields would thos be? Can you give a little more detailed info? I think you may need to look at updatable, parameterized, local views to do what you want.
Mark McCasland
Midlothian, TX USA