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

Snow12
Kilo Contributor

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)
Field1Field2
data 1details
data 2details
data 3details
data 4details
  

 

Child Table
Field1Field2Flag
data 1details"true"
data 2details"true"
data 3details"false"
data 4details"false"
data 5details"true"
data 6details"true"
data 7details"true"
data 8details"true"

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

find_real_file.png

 

1 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 

-Anurag

View solution in original post

4 REPLIES 4

Anurag Tripathi
Mega Patron
Mega Patron

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.

-Anurag

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

 

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 

-Anurag

Hey t_anurag,

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