Hello.



I have a form (related to table) which is populated with 10000+ records.
However the records are just contain the address information until a surveyor completes the remainder using the form.
As per picture.

I want to be able to clone records, however this must not be a simple clone where it duplicates the address also.
What I need is to say (i.e.)

Select address from complete surveys
>Surveyor picks from an address list of surveys they have completed.

Clone record to
>surveyor picks an address they want to clone the data to.

Complete
Form opens up focusing on that address which has just been cloned to.

But it must just clone certrain fields (data)

Can this be done.

I think the pictures attached might make it clearer.

Thanks