How to create a new table by clicking one on cell?

[JoDraw]

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

[Seth Schrock]

It would be better to have one table for all of the different segments and just have an additional field that identifies the parent sample. See Database Normalization and Table Structures.