I am trying to copy the contents of a container field from one table to a new record in another.

 

Is there a way to do this without finding the specified record, then importing that table into the second table?

Additionally, if this is the only approach, how do I script it to select the correct table to import from? I cannot seem to find this...

You mention both copy and import... can you explain a bit more what exactly you want to do?  To get content from one field to another typically does not use either copy or import, but the "set field" script step.

 

Without knowing the purpose, the fact that you will have the same data in two different records sorta goes against the normalization principles...

You mention both copy and import... can you explain a bit more what exactly you want to do?  To get content from one field to another typically does not use either copy or import, but the "set field" script step.

 

Without knowing the purpose, the fact that you will have the same data in two different records sorta goes against the normalization principles...

 

I have a record in one table, that contains a Container field, that I need to then duplicate into another table.

 

Previously, I had been setting all the fields as variables, and then move to the new table, create a new record, and set the appropriate fields from the variables.

 

However, I cannot do this with container fields.

 

If I find the specified record to make it the only record in the found set, and then manually import it to the new table, it is fine. However, I cannot figure out how to script this, to select the table to import from within the file.

 

While writing this, I figured I could set a global container variable, and store the container info there, while the rest uses variables.

While writing this, I figured I could set a global container variable, and store the container info there, while the rest uses variables.

 

That's the approach that I would recommend.