From: nomail@nospam.com   
      
   Hi Kenneth,   
      
   You mentioned that you were editing with a MRO,   
   and I understand that,   
   but I am not sure I understand the whole picture yet.   
      
   Is this a header / detail kind of relationship,   
   similar to an invoice with many lines,   
   or a production item with inventory items needed for production ?   
      
   Do you go thru a process where you have to pick the   
   header or master record,   
   and then you add the detail lines ?   
      
   If you do figure out a way that adds the 1,2,3, etc,   
   and then you renumber them later,   
   will the original key be located elsewhere and need to be changed ?   
      
   Do you do the data entry right in the original table ?   
   or do you keep empty tables ( or create temporary tables) for data entry,   
   and then "post" it to main table when user hits save ?   
      
   In some situations,   
   I have created empty temporary tables on the fly,   
   using the create like syntax,   
   but I do not key this table.   
   I then allow users to data entry into the temporary table,   
   if they hit cancel , I just empty temp table, or delete it,   
   and then if they hit save, then the fun begins.   
      
   If adding new item, then all rows need to be added elsewhere.   
   If editing an item, then I delete all items matching the header ,   
   and then add all the detail records.   
      
   For these detail records,   
   when the user clicks save,   
   I end the edit mode,   
   and then simply run a tcursor scan/endscan on that temp entry table,   
   to add sequencing number,   
   then close tcursor,   
   and then do table add or insert query as necessary   
   to move these records into approriate table.   
      
   Keying the temp data entry tables for me introduced headaches,   
   and since I was editing in an empty table,   
   I really didnt need it.   
   I just had proper code in my save routine.   
      
   I think this is better way if you are doing client / server also.   
   Sort of like creating little batches, that must deal with the server.   
      
   Not sure if that makes sense or is applicable in your case.   
      
   Still doing any linux,web, or mysql stuff ?   
   IIRC from other posts, you were doing some fun things with that.   
      
      
   Good luck   
   Robert Wiltshire   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)