Hey guys, I have just about got everything working. The last thing I need to do is connect two databases via one unique number... The first database is setup with all the information we want to keep forever(name, date, score, case type, manager) and then the second database holds the results of the audit scores, but will only hold them for 3 months. So I have a form setup with all the questions. When the form is submitted the score is added together, and then put into the main database. Each record in the main database has an id, which is auto increment. How do I get that auto incremented number into the id field of the second database at the same time as the answers to the questions?? Any clues? Thanks.