Create one Child Record per Year
Each Parent record needs an annual review. I want to avoid someone creating two records for the same year. However, since I can't use a look up field (Parent Account#) in a unique field formula, I do...
Forum Discussion
Can you just have a summary field check to see if a review exists during the current year, and simply hide that add review button if one exists? (Or you can even make a formula rich text button that says 'Add Review' when does not exist, or 'Edit Review' when one does exist.
------------------------------
Mike Tamoush
------------------------------