Hi All! What I'm struggling to do now is combine the 2 tables below into ONE recordset for my division's new employee test program. As of now the 2 tables aren't linked, because I didn't see a need to do so. So can I use a CROSS JOIN to bring all the records from EACH table into the recordset? OR is it easier to establish a (basically useless)link between the 2 tables & use an OUTER join based on needing to get ALL the records from Table 1?

Table 1

Autonumber Primary Key
Question
FirstAnswer
SecondAnswer
ThirdAnswer
FourthAnswer
CorrectAnswer

Table 2

Autonumber PK
TestName
TotalNumberofQuestions
NumberofTestQuestions
NumbertoPass
DateofTestDesign
TimeLengthofTest

As you can see, there's NO correlation between the two, other than the fact that the 2 tables COMBINED make up the stats for the new employee's test. I want to try to keep everything in 1 disconnected recordset which I can update after I finish writing the test questions. JHauseman & others already helped in regards to writing 2 separate Update commands to SAVE the data when done-but I forgot to consider how to start the whole thing! <sg> ANY help would be appreciated! Thanks!

thomas