I am assigning the location to the customer. Customer number
and name kept in page header, location and checkbox kept in grid. I am storing
the details with the following information: customer number, name, location and
checkbox field. The constraint is, in grid under location field there are n
number of location but user can assign only one location to the particular
customer. After selecting first checkbox if user try to select another checkbox
user should message that "You cant select multiple locationcode for the this
customer", I mean user can not select more than one checkbox. It should happen the
same while you are displaying the record. Suppose for cust1 you already assigned
location(with checkboxmarked), while you are displaying cust1 information in
the grid corresponding checkbox also be displayed. In this regard I would like
to request to all expert to write one stored procedure to handle this situation…I
want to handle this in back end. Pls help me somebody…..
Thanks,
Rahul