I have a database of 6000 samples.

When a sample is chosen it is sliced into 50-100 segments.

I wish to make a new table each time a sample is used with each daughter segment incorporating the original samples ID into its own ID but allowing it to be also subsequently tracked independently in the new table.

Can I use a macro to design this process automatically?

Thanks