Skip to main content
Topics#Data ManagementMark Graham의 질문
Mark Graham (Fujifilm Australia) 님이 #Data Management에 질문했습니다
2014년 9월 2일 오후 12:08

Validation rule help: Multiple records, but we only want one to be flagged as current (checkbox = true)

I have two objects, IT Asset (Parent) and IT Asset Owner (child) in a MD relationship. We would like to keep track of the different owners of an IT Asset over time so have a child object and related list of historical records but would like to only ever have one record flagged as the current owner that updates a text field "Current Owner" on the parent IT asset record. How can I ensure there's only ever 1 IT Asset Owner with "Current Owner" check box = TRUE?

 

Thank you for any ideas/help

 

Regards

 

Mark
답변 7개
  1. Prakash B
    2014년 9월 2일 오후 12:27
    Hi Mark,

     

    You can create a unique field in the IT Asset Owner object. The unique field will be updated through workflow and will have the corresponding IT Asset ID (Parent) and the value of the checkbox (True or False).

     

    So when a new IT Asset Owner and the checkbox is flagged,this field will not be unique and hence will display notification along with the link to the record currently flagged.
답변을 작성하세요...
0/9000