I am sorry, I just assumed you would know it had a subid in the subscibers table and a subid, dependentid in the dependents table. I am aware of how to do that, but what I have done is place the results of the dependents into a 2 dimensional array that loops until is grabs all of the dependents with the subid the match the subid of the subsciber. My question is once I have that information into the array, how do I pull it apart and update the database if information has changed? Do I need a separate Recordsets and Select statements for each? Or is there a way to loop through the array and update the correct record?