0

How can I limit the creation of child records depending on a variable from the parent record?

Hi:

I have a parent table called TABLE_A and its child table TABLE_B. TABLE_A has a field called STATUS with possible values are OPEN and CLOSED. I want to restrict the creation of child records in TABLE_B when the status of TABLE_A STATUS is CLOSED. Can you please let me know how can achieve this with Ninox.

Thank you very mauch

1 reply

null
    • John_Halls
    • 3 yrs ago
    • Reported - view

    I think the best way to do this is create a View in TABLE_A. Place this underneath the Relationship field In the formula put TABLE_B. In Display field only if: put STATUS = "CLOSED" and for the Relationship field in Display field only if: put STATUS = "OPEN"

    Now as you toggle from OPEN to CLOSED the diplay moves fromthe relationship, which is editable, to the view which is not. You can still click into the TBLE_B record so in TABLE_B add in Writable if: TABLE_A.STATUS = "OPEN" to prevent it being edited.

    Regards John

Login to reply

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 343Views