SQL help needed.

I am running Informix SQL Version 2.10 and I am trying to enter values into several fields in a given form. Once these values have been entered I want to update all of records ( by their inventory numbers ) that I apply these values to. This would be a type of batch update where all of the inventory numbers that are entered would be updated with the values entered for the given fields. If I have to update the same values every time for 100 different inventory numbers it becomes extremely tedious. The goal is to enter these values once and then enter the inventory numbers that they will apply to for the update. I have spent a lot of time trying to figure this out and I want to do it only in this Informix SQL. Can anyone help? EXAMPLE: These are fields where the values will be input to: Salesman: [a1 ] Date Given: [f015 ] Date Sold: [f016 ] Customer: [f017 ] Cust. PO#: [f018 ] Inv/memo#: [f014 ] Inv or Memo: [c] (I,M,N,O) The values entered above should update records for the multiple inventory numbers to be entered in this field : Inventory Number: [f000 ] BELOW IS THE PERFORM FORM THAT NEEDS TO BE MODIFIED ------------------------------------------------------------------------------------------------------------------ database northern without null input screen { NORTHERN - SALESMEN INVENTORY UPDATE Inventory Number: [f000 ] Item Number: [f001 ] Color: [b] C. Weight: [f003 ] D. Weight: [f005 ] Selling Price: [f011 ] Salesman: [a1 ] Date Given: [f015 ] Date Sold: [f016 ] Customer: [f017 ] Cust. PO#: [f018 ] Inv/memo#: [f014 ] Inv or Memo: [c] (I,M,N,O) } end tables inventory detail mountings attributes f000 = inventory.invnum, noupdate, required; f001 = inventory.itmid, noupdate, required, upshift, picture = "A-####", default = " - "; b = inventory.clr, noupdate, upshift, default = "."; f003 = inventory.clrwgt, noupdate, format = "##.##", default = .00; f005 = inventory.diawgt, noupdate, format = "##.##", default = .00; f011 = inventory.selpr, noupdate, right; a1 = inventory.sman, upshift; f015 = inventory.dgiven; f016 = inventory.dsold; f017 = inventory.cusid, upshift; f018 = inventory.aux1, upshift; f014 = inventory.comm2, upshift; c = inventory.qques, upshift, include = ("M","m","I","i","N","n","O","o"); end ----------------------------------------------------------------------------------------------------------- Any suggestions would be greatly appreciated. Sam Glattstein