im very a newbaby... <BR>my first for loop is extracting data from the "passenger" table and within the "for" loop ive an "if" statement that calls "supplier" table. how to do that? I couldnt find the source code from the wrox book. <BR>alright..the first thing to be done is set the connection next deal with the recordset in this case both tables... generate the sql statement...and set the table to nothing.. But i couldnt open both table..Help..where did i go wrong?????????