copying from main to response
Posted on 2006-05-11
I have a form in db saved with thousands of document. This form has only 3 fields:
field1 - place
field2 - product
field3 - amount
Now I want to split these into 2 forms, a main and a response so that I am able to create many products per place and I did that.
form 1 - main form has the following field
form2 - response to main has the following fields
where were originally in main
Now that original database, had thousands of document which I need to copy across with the above main/response split instead of all in the one document.
Is there a quick way to do this, as this is a critical database and can make no mistakes.
I need that I have to match on univeral ID to avoid duplicate or loss of data, however a more precise solution, maybe a small script to help will be appreciated.
Thank you in advance.