This may seem like a really stupid question but I've never updated a relational DB from asp before.<BR><BR>I have the code to connect to the database and update data fine. The problem occurs where the tables have a tree structure but all of them have one thing in common - a user id number. I need to update all the tables at once, but the database will only let me insert data into the central table that all the others branch from. Is there a way to insert data to the whole tree? Or do I need to return the unique user id assigned when I insert a record into the central table?<BR><BR>When I try to insert data into tables other than the central one there is a constraint problem - it won't let me specify the user id and it won't let me leave it blank. Please help!!!<BR><BR>I'm using SQL Server 7.0.