Skip to main content
Question

Unique ID of child for associated Parent

  • March 9, 2021
  • 0 replies
  • 24 views
Forum|alt.badge.img+6
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
... set permissions to not allow delete.  Just let them flag as deleted and filter those off reports.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement