Skip to main content
Question

Move Fields permanently from Parent Table to Child Table

  • March 25, 2022
  • 0 replies
  • 52 views

I have a design flaw in my App that I would like to correct.   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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

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,  now you have a scalar data entry field that knows the correct value for the Relationship

Make the relationship based in that field.

rename the reference field from 
[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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement