Informix ISQL problem

Hello everyone, I am having a slight problem with two linked tables. I have an parts table and a partscount table and I need to delete a large number of parts from using a parameter in a single field. This part works fine exept that the partscount table needs to be updated as well. I can't seem to find the commands to coordinate the deletion of the parts and the actual parts count in the other table. They are both linked by a field called part_link, I just don't know of a way to do a delete on two table at once. I wasn't able to select both for a delete at the same time. Oh, and the parameter that I am using for the delete is only found in the parts table and not in the partscount table. So, if anyone has any suggestions, It would be greatly appreciated. Thanks in advance, Brian brianr@magnus1.com