Hello everyone, I also sent this to the zope-db list, which I found from the Zope News...but I thought I'd go ahead and post this here as well, since the readership on that list is likely to be quite small since it's a new list, with only 6 messages on it... I'm working on a gradebook program for (using an SQL db adapter) teachers, and at this point I want a teacher to be able to add an assignment. I've got a basic table that has the student name, id, assignment, and grade, with a row for each assignment/grade for each student. I'm at the point now where the teacher adds a new assignment and I want <something> to go through the table, and create new rows for each student, but with a null value for the grade which will be entered later. How do I do that? I'm thinking of just going through the table with a SELECT DISTINCT student-id clause (that way I only create the rows once for each student assignment), but that seems like two steps, one for the SELECT DISTINCT, but then adding new rows based on that query is baffling me. Thanks for the help! Russell