Do you really need to duplicate the records? If the style specification is the same can't you have two different garments link to the same style specification but specify the different fabric?
Unfortunately, no, because even though the Quantity / Size / Application of buttons - are the always the same for the coat, the record needs to have fields with flexibility to select type of buttons.
The code of the button type is completely different from the same style of coat if the fabric is different and there need to be option write in different button code. i.e.: for the leather coat, we use different button from wool coat.
Consequently there is a field to select cololurs of buttons from available colours from the button code for the users. That's why I have to give Spec ID to every style/ fabric rather than based on Style No.
Based on that what would you be able to help me?
If I have this correct, you want to duplicate a record but also need to duplicate a set of records related to it. In other words, you need to duplicate a parent record an also all of its related child records.
If that's correct, see the script at the END of this thread: Duplicating Bill Of Materials (duplicating portal line items)
Without duplicating the ' parent' record.
Basically Spec Sheet might be created with blank data in portal initially, and later on the users can select an appropriate Spec_ID to copy & paste the contents of portal from another record.
This way it gives more flexibility to " change" the record contents as & when we need but also the records in Spec Sheet is mainly set up to be created from a portal row of another related file.
would it be more complex this way?
A variation of the script in the thread should be able to do that.