Hi,<BR><BR>i want to insert several different fields in different tables.<BR>All those tables have an primary key wich is autonumbered by SQL server 7.<BR>One table has multiple foreign keys to the other tables wich are inserted. <BR>The problem is that I don&#039t know wich number will be given by the autonumber function to the tables and so i now first fill the tables with the autonumber primary keys.<BR>Than check to see what wich number is given and put those in the &#039link&#039-table.<BR><BR>is it possible to do this all in one ?