Hello Karen,
I think this is technically feasible, but it will be a complicated solution. A custom field can't do it since custom fields can only access the current object's data and not the data of other objects. The implementation will depend on your exact requirements — I recommend working with your PS consultant on this.
Thank you,
Roland
Comment actions