Lotus Notes: Copying data from one database to another when fields don't match
Posted on 2006-05-11
I need a button on a form which, when pressed, creates a new form in another database, copying data from one set of fields within the form being created to another. The simple "copy to database" action would be perfect if the fields matched. Unfortunately they don't, and there is a lot of existing data in both databases so I can't match them. However, the field types do match. So basically the button needs to create a new form in the new database and take the information from field a and put it into field b, etc. I have about 5 fields, and although the data type matches perfectly, none of the field names are the same. I'm not conversant with Script (though I'm using Notes 6), so would prefer a formula, but if script is the only option, could you possibly provide the whole script formula with something like "field a copy from" and "field a copy to" in so I can replace it with my data with a minimum of knowledge. Thanks very much for your help! I think that the question is an easy one (for a decent programmer rather than someone like myself!), but perhaps a little fiddly so I've given it 125 points.