sorry for the poor topic title, but couldn't think of alternative. firstly, i have table `boxes` which is read and displays ok with default select statement. what i need to do, is display boxes data to user, but when user adds a box, i need to enter into temp table for action before entering into `boxes` table. once the action table has been done, then insert data into `boxes` from the `action` table. hope that is clear. many thanks.