Hi,
I have the following scenario where I have a list of orders and each order needs to be allocated to one or more sales people (sometimes more than 1 sales person can be involved in an order). I have created a master-detail form that shows up in the order entry form.
I need the following:
-
The drop down (select) field to list the sales users need to show the “remaining” sales users. By this I mean that if 1 user has been allocated already, his name should not appear in the next record’s select field. Is this possible? I am trying to do this such that the same user cannot be selected multiple times. I know I can do this in a validation, but I was trying to see if I can restrict in the UI itself.
-
I need to validate that the sum of allocation of each sales person mentioned equals 100. I know this can be achieved in the validation event, but I wanted to know where? In the master-detail form’s validation OR the container’s (in this case order form) validation event?
Some examples or a link to a webinar would be very helpful.
Regards.
Viral Shah