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]

A question to get better clarification...when you mention the OOB Location table, are you referring to the cmn_location table?  If so, I don't believe that table can be extended.  There should be a field called 'is_extendable' and I believe the value is set to false.

[Teresa8]

Yes, the cmn_location table. I checked the box to make it Extensible. I've had to do that for other tables, like the sn_customerservice_case table.

[alexcha]

Ahh...okay, I had assumed you wanted to leave the cmn_location table alone to keep it OOB as you did not want to add custom fields to it.  I know this table is a bit different as there are a couple of reference fields that refer back to itself, I don't know if this will complicate matters if you were to extend it.  How many custom fields were requested to be added?

[Teresa8]

So far 6 fields. But there will be more in the near future.