Forum Discussion

CassidyPhillips's avatar
CassidyPhillips
Qrew Member
7 years ago

Automatically create a parent record when info saved in the child reference field

Hi, I currently have two tables in a parent-child relationship: effectively I've got 100 parcels in the child table and each parcel is kept in one of ten boxes, which are kept in the parent table. Rat...
Data import and export
Relationships
Tables and fields
DeepaPrashant1's avatar
DeepaPrashant1
Qrew Cadet
5 years ago
I need to do this as well. But my table relation is such that each parent can have multiple children. So when multiple children are created belonging to the same parent, the Quickbase action is creating multiple parents. Is there a way for it to ascertain that it is the same parent and not create duplicates? QB support has said this is not possible and hoping you have a workaround.

Thanks in advance!!

------------------------------
Deepa Deepa
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Are your children being created via an import or just one by one.

If being created one by one, why will the above solution not work for you.  Does the child record know the correct value for the Parent's Key field?  What is your definition of a duplicate parent?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • DeepaPrashant1's avatar
    DeepaPrashant1
    Qrew Cadet
    5 years ago
    Hi Mark!

    Data is being imported. The the key fields for the parent are included in the child import and the QBaction triggers the creation of the parent using those key data fields. Then another QBaction on the parent table triggers linking that parent to the child using a report link field (to link the newly created record ID of parent to imported child).

    Assume I have two children with record IDs 234 and 235 and both belong to one parent with same parent key fields. As soon as parent with record ID 9876 is created for child 234, it should also get linked to child 235. Right now, when the children are imported two parents are created with different record IDs. Within each parent I can see only one child.

    Is this doable?

    Thanks

    ------------------------------
    Deepa Deepa
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      I think it's possible but some clarification first. What is the Key field of the parent table?  Is it Record ID  and a separate field is the value that needs to match the Child?

      if that is the case, can we change the Key field of the parent to that Key field as part of the solution, or is that not an option. 




      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • DeepaPrashant1's avatar
        DeepaPrashant1
        Qrew Cadet
        5 years ago
        Mark,

        You are right. Currently the key field is just the record ID. The other fields that would uniquely identify the parent would be not one but multiple fields :Run Date, FileTime & Related Bot. A combination of these would identify it as the unique parent. I guess I could create a formula field that stitches these together and make that the key field?

        Thanks!

        ------------------------------
        Deepa Deepa
        ------------------------------