Forum Discussion
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
------------------------------
- AnnettaColeman4 years agoQrew Cadet
Update: There were actually 134 fields. I was able to copy the table, deleted the unnecessary fields and create the relationship easy enough.
How do I copy the complicated form formatting to the new table?
------------------------------
Annetta Coleman
------------------------------- AnnettaColeman4 years agoQrew Cadet
LOL. Never mind. I discovered that copying the table also copied the forms.
Mark -- Thanks so much!
------------------------------
Annetta Coleman
------------------------------- MarkShnier__You4 years ago
Qrew Legend
It a great method because it's a "2 'fer". You get the form & fields, but also an easy way to connect the Children to the correct Parent.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------