Is it possible to import Parent table records to child table ?

[Snow12]

Hello,

Is it possible to import parent table data to a child table ?

I want to create a new table which extends an OOB table in order to have the same data in my table so i can add a Flag and also add other data.

Parent table (OOB)
Field1	Field2
data 1	details
data 2	details
data 3	details
data 4	details

Child Table
Field1	Field2	Flag
data 1	details	"true"
data 2	details	"true"
data 3	details	"false"
data 4	details	"false"
data 5	details	"true"
data 6	details	"true"
data 7	details	"true"
data 8	details	"true"

The goal is to show only the "true" record when child table is used in reference field.

[Anurag Tripathi]

Yes, you can do it.

You can copy the record in child table from the parent and populate the 3 fields accordingly.

But looking at your requirement, i feel you would be better of(and easier, less messy) if you just create the flag on parent table itself.

[Snow12]

Thanks for the answer,  yes it would be better if we can change OOB table without skipping it on upgrade.

[Anurag Tripathi · Accepted solution]

Hey Snow,

You are not changing anything on the table definition and creating a new dictionary entry. so it wont really matter in the upgrade, if you change/modify any existing oob field, then that field would be skipped in the upgrade. In your use case you should be fine creating the flag on parent(oob) table

Please mark the answer correct/helpful and close the thread.

-Anurag 

[Snow12]

Hey t_anurag,

Thank you for the answer, that's what i will do 😉