I have two relational oracle tables. I collect the data thru asp forms. When I write to table A, i need to retrieve the PK (which is a user sequence incrementing by 1 each time) and use this value as a FK in table B. How do I lock table A to prevent to concurrent insert statements that could use the wrong FK value? ie. I want to lock table A, write to table A, select max(pk), release lock, write to table B with the FK. AN ideas...please help!!