From: isgdre@HotMail.com   
      
   Hi, I have a table that contains order information,  each row contains   
   information about a detail item that's been order but the key is OrderID   
   and LineNumber.   
      
   I'm trying to insert information into the table from another table but   
   other table does not have any type of line number information.  Also   
   there is now hard value for the number of rows already in the order   
   detail table.   
      
   Is there a way to use “Insert into....” for this problem?  I.e   
      
   Insert into OrderDetails od (OrderID, Item, Description, LineNumber)   
   select OrderID, '!NOTE!', Description, od.@ROWID() from OrderNotes   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)