Import/copy data from parent table to extended table

[Teresa8]

I've been instructed to add quite a few fields to the OOB Location table. I don't want to be "that" person who mucks up a base table with a lot of junk that a future admin will be scratching their heads about, so I think extending the table would be better. On the new extended table, how do I get the data (not just the fields, but the list of locations with their addresses and all of the other populated info on those fields) to the Child table? Is there an easy, no-code way to do this?

[alexcha]

I would be interested in the thoughts of others in the community. 

I would be hesitant to extend this table as I would worry about the negative impact due to fields referencing back to the 'cmn_location' table (the 'is_extensible' field may have been left unchecked for a reason).  

I do appreciate not wanting to add custom fields to the OOB table (thinking about future developers/admins), but I also acknowledge the customers' requirements needing to be met (unless the desired goal can be achieved in a different manner).  If you need to go down the road of creating the custom fields on the cmn_location table, I would find a way to document:

• What you did
• Why you did it
• Other considerations taken into account

This will provide future users a better understanding of what was done.

[alexcha]

A different approach that came to mind:

1. Create standalone table
2. Create the 6 required fields on the new standalone table (additional fields can be added to accommodate future requirements)
3. Create a single field on the cmn_location table referencing the new standalone table

You can display columns from list view and fields on the form to the standalone table by dot-walking.  With this approach, you are limiting what you create on the cmn_location table and providing flexibility with the new standalone table for future requirements.

[Najmuddin Mohd]

Hi @Teresa8 ,

I would prefer to create custom fields on the OOB table, since creating a custom table would cost the license.
You can document about the custom fields and give the Knowledge transfer to the future admin.

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin.

[Teresa8]

I appreciate the thoughts and opinions and guidance on whether to create a new table or add fields to the existing OOB table for this. Back to the original question: is there an easy way to copy or import the data from a Parent table to a Child table? Can anyone help with that?