Skip to main content
Question

Prevent Duplicate Entry from a Record Picker

  • Mar 11, 2024 8:37 PM UTC
  • 0 replies
  • 161 views

Forum|alt.badge.img+19

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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9
  • Qrew Colonel
  • Mar 11, 2024 8:47 PM UTC

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
------------------------------