I have a database that has user defined exceptions. There is a list of exceptions that the user is allowed to add to.
Each customer can have many exceptions.
Currently we store all the exceptions for each customer in a seprate table, we only keep the ones that are true.
I want to create a BO that will show all the current defined exceptions for each record and allow the user to select or unselect exceptions. How can I do that if not all customers will have all (or any) exceptions at any one time? Can I create a BO that holds all of the defined exceptions and have it show the ones that apply to the current customer? Then be able to save new/deleted ones?