Ok, this is kinda confusing i know, but bear with me. I am entering data into a table that has a primary key (ProductTypeID) and one other value(Description). I am using a sequence to create the primary key number and the other value is just a varchar. The problem is, the ProductTypeID is a foreign key in another table which i insert just after the first insert. Is there any way to bring back the ProductTypeID after i insert it, so that i can insert that newly created number into the next table??? I tried Seq_ProductTypeID.currval, but it doesnt seem to be working. Any other way of doing this, im stumped??