Forum Discussion

SarahBurres's avatar
SarahBurres
Qrew Trainee
4 years ago

Unique ID of child for associated Parent

Relationship: Orders have many Defects

I have made a snapshot record that takes the maximum number of child (Defect) associated with the parent (Order) and that becomes the new record ID for the Defect.  
"CR-"&[Order]&"-"&[Snapshot]

The issue is that if the user deletes a child record, then there become duplicate Defect numbers. 


------------------------------
Sarah Burres
------------------------------
  • If your setup is Orders<Defects, I'm unclear why you're using a Snapshot of the Summary of Max Record ID# from the Defects. Could you not just use the Record ID#? 

    Also, I would encourage you to create a way for your users to mark a record as "Invalid" or something similar instead of giving them the ability to delete. This way, you have all of your historical data that you can look back on.


    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------