StrataFrame Forum

BO Map - one to many

http://forum.strataframe.net/Topic4699.aspx

By Jon Olson - 11/21/2006

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?

By StrataFrame Team - 11/21/2006

Yes, you'll probably be able to accomplish that by adding an extra column to the business object that can act as a flag for the records that are user define, and the records that are "default."