Move Fields permanently from Parent Table to Child Table

Question

I have a design flaw in my App that I would like to correct.&nbsp; &nbsp;Please help?
Problem Statement: I have a large app with a Primary Parent Table and numerous Children Tables. I recently added ~50 fields to the Parent Table that really should have been designed to be in a new Child Table. These 50 fields are displayed on a single tab on a complicated form. This is a new design feature and is currently hidden from ~200 users.Desired State:- I would like to move the 50 fields to a new Child Table- I would like to move the form tab to a new form associated to the Child Table.What is the most efficient way to achieve desired state?------------------------------Annetta Coleman------------------------------

markshnier__you · Answer

Easy.Go to the table home page on the old report style and click Copy This Table with data
Now you have a duplicate table named new child table and even the Record ID will be preserved.Now we need a relationship properly populated.Create a new field which is called for now, [link to parent]
Make it a formula equal the record Id.Change it back to a numeric field.Great, &nbsp;now you have a scalar data entry field that knows the correct value for the RelationshipMake the relationship based in that field.rename the reference field from&nbsp;[link to parent]
to Related Parent (or whatever you parent table is called.So now just massively hack away and delete all fields that do not belong in the child.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

annettacoleman · Answer

Update:&nbsp; &nbsp; There were actually 134 fields.&nbsp; &nbsp; &nbsp;I was able to copy the table, deleted the unnecessary fields and create the relationship easy enough.&nbsp; &nbsp;

How do I copy the complicated form formatting to the new table?------------------------------Annetta Coleman------------------------------

annettacoleman · Answer

LOL.&nbsp; &nbsp;Never mind.&nbsp; &nbsp;I discovered that copying the table also copied the forms.&nbsp; &nbsp;
Mark -- Thanks so much!&nbsp;&nbsp;------------------------------Annetta Coleman------------------------------

markshnier__you · Answer

It a great method because it's a "2 'fer". You get the form &amp; fields, but also an easy way to connect the Children to the correct Parent.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Move Fields permanently from Parent Table to Child Table

4 Replies