I have a table view that groups my records by Open or Closed. When the user selects a record, the Form view displays the parent record and related children from various tables. The related Child records view within the form displays the list of children with the option available to add a record: New (see below). However I need to prevent the addition of new records if the displayed Parent record is closed. How can I do that?
I don’t know if it’s related, or a separate problem, but the I would have thought the Related Records list would also have had a View option. Or could that be because I have customised the standard form to Group the related records (see below).
I assume you mean Steve’s solution - create two related records fields, and Show the Read Only version for closed records? Is that what you’re suggesting?
Thanks for the solution. I’m not sure how to close this question now, but there’s one other problem I have that is visible in the screen shots and I am not sure if I need to raise it in a new question or can ask for a little more help on this one.
The related records only allow New but on other apps and views I also have the View option, that doesn’t appear here. Does anyone know why?