Forum Discussion

SarahBurres's avatar
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.  

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

Sarah Burres

1 Reply

  • 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
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 /