Filter lookup to prevent selection of previously selected values
I have a main form which stores profiles of children. A second form creates a health record for each one. I only want one health record per child. The health record's first field is a lookup to select the child it stores health information about.
How do I dynamically adjust the pick list to only display the names of the children who have not yet had health records created? I assume I need a Deluge script for this and it's a bit beyond me at the moment. (Still learning!)
Any hints would be appreciated!
Jennifer