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
-
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
Content aside
- 3 yrs agoLast active
- 1Replies
- 345Views