Skip to main content
Question

Prevent Duplicate Entry from a Record Picker

  • March 11, 2024
  • 0 replies
  • 129 views

Forum|alt.badge.img+15

The objective is to prevent adding a child record to a parent a second time from a record picker.

A simple business case is adding parts to a Bill of Material from an Item Master.

A given Assembly might need 30 parts from the 10K in the Item Master and I am trying to make sure that the User cannot pick the same one a second time.


------------------------------
Don Larson
------------------------------

Forum|alt.badge.img+9
  • Quickbase Alumni
  • March 11, 2024

How are they being added? Grid Edit? Will a simple formula text field that you concatenate Related Assembly & Related Item Master that you set to unique suffice? 



------------------------------
Chayce Duncan
------------------------------