Copy repeating table entries to inserted section

[byeo]

I am developing a form to be used in a manufacturing environment that will
store Bill of Material (BOM) data (how much of each raw ingredient is needed
to make 'X' amount of finished product). For one finished good there may be
several Bills of Material depending on which line at a plant it is made on.

I am using a repeating section to store the different plant/line
combinations that produce the material; the actual raw materials that make up
the BOM for a given plant/line are stored in a repeating table within the
repeating section (basically the plant/line is the header and the BOM
components are the detail).

When a user inserts a section to add a new plant or line that the material
will be produced at I would like the data entries from the BOM repeating
table to be copied into the new section's BOM repeating table. Is this
possible? I am only moderately comfortable with coding but if that is the
only option I'd give it a try.

Thanks,

 

[Franck Dauché]

Hi,

As you guessed, using code behind would be great way to do this. Make sure
to use Managed Code (I would say C# as you will find a lot of code samples on
the Web to get you started).
Each time a plant/line is added, you can use the OnAfterChange Event to
pre-populate your raw material data based on some reference somewhere.
If you are not confortable with coding, this may seem difficult; but you
will benefit from it in the long run, as the business rules of your BOM will
only become more complex as you get feedback from your users. Code behind
will gve you the flexibility that you need.

Good luck.

Regards,

Franck Dauché