Posted 07 August 2006 - 09:38 AM
I have a form that has been filled out, and then stored in a DB and now another person (the boss) wants to review the form, and add comments and a purchase order #(that wasn't available on original form). Other than adding the purchase order # and comments the forms will be identical. Is it the SELECT query that I would want to use to get all the data back into the form? None of the original data will be changed, just the 2 new fields will be added to the DB when he is done reviewing it. He will know the work order # and this is what will be used to SELECT the proper record.