Help with Insert (ESQL/C)

Howdy! I have a scienario where I need to insert into one table and one of the columns of the table is of serial datatype. After inserting into this table, I need to know what the column value is ( the serial type one) and insert this value into another table where it is a foreign key. I got the stuff working by inserting the row and then quering using the select statement. USing this value I insert into the next table. Due to voluminous data we have, and to improve the performance I was thinking of eliminating the second query. Is there any other way that I could accomplish the same thing?( ie with out quering using the select statement?) . I would appreicate if you can either mail me or post it on the news group. Thanx Potluri Dora -- Potluri Dora Information Systems Lab Clemson University Clemson, sc 29631