Next problem:

VB.NET application, Access w/ SQL statements

I have a "Select GAS_SERV" on a parent table that joins with a child table and confirms that 2 fields are the same (along with some other parameters) and the deletes the row per the GAS_SERV number from the parent table. (Im just learning how to do all of this so bare with me) I did that as practice and I have that down. What needs to happen is the 11 child tables that have that that GAS_SERV number needs their rows deleted also.

If I delete the rows from the children first, I wont have the fields that I checked the parent against to delete the rows from the parent table. (I am confused too)

What I think I could do is have a select statement that would get the GAS_SERV numbers I need to fill a dataset, get those numbers into an array, then loop those numbers through a delete statement, I think that would solve my problem.

First question: Did that make any sense at all? Second: What would you do if you understand my problem? Third: How do I get the dataset records into an array (if thats a good idea)?

Thanks again.