I created two tables: Table1 has fields: author_id (uniqueidentifier), author_name (char). Table2 : book_name (char), author_id (the foreign key from Table1). I inserted into Table1 a record that its author_id was generated by NEWID() function. After that, I inserted into Table2 a record which had author_id was the same as the record in Table1. To do that, I wrote down the value of author_id from Table1 and I carefully typed it into author_id (Table2). How could I do to make life easier. Thank U.