OK, I'm stumped

Here's my dilemma: 2 tables and 2 others that have current data in them. The 2 tables that have the current data in them I know how to display, the problem I am having is the 2 tables I need to transfer information to have to have the same key in one location Tables: CREATE TABLE store_orders ( id int(11) NOT NULL auto_increment, order_date datetime default NULL, order_name varchar(100) default NULL, order_address varchar(255) default NULL, order_city varchar(50) default NULL, order_state char(2) default NULL, order_zip varchar(10) default NULL, order_tel varchar(25) default NULL, order_email varchar(100) default NULL, item_total float(6,2) default NULL, shipping_total float(6,2) default NULL, authorization varchar(50) default NULL, status enum('proceed','pending') default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Table structure for table store_orders_itemmap -- CREATE TABLE store_orders_itemmap ( id int(11) NOT NULL auto_increment, order_id int(11) default NULL, sel_item_id int(11) default NULL, sel_item_qty smallint(6) default NULL, sel_item_price float(6,2) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; The 'id' of the 'store_orders' table HAS to be entered into 'order_id' of the 'store_order_itemmap'. I am having the problem because I can't figure out how to logically make that happen in 1 step, moving everything from the 2 tables they are currently in (a temp table of the customer information a temp table of the order'. I use the session ID to track the temporary stuff, but once they commit it to an order I need a different number. They are allowed to make multiple orders on the session ID and changing a session ID is not working for me (destroy and start on the session do nothing). HELP! TIA!! Robert ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Genius does what it must, and talent does what it can. -Owen Meredith. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~