>>>I have a table called avIssues which contains patient issues. The issues stored in this table come in two basic types called IssueType and they are 'Billing' and basically everything else.
>>>
>>>There will be edit screens to allow the user to create and manage issue types. Right now there will be logic that says:
>>>
>>>

>>>if the issue is billing
>>>
>>>  Gather information about the issue such as billing amount, date of service, etc.
>>>
>>>otherwise
>>>
>>>  Store notes about the issue in RTF format
>>>

>>>
>>>The problem is that right now I need to determine if the item is a billing issue. I can see later on the client wanting code to take action based on different codes.
>>>
>>>The question is what's the best to set up the data so that I can code a CASE statement later? I could use a code in the table, but this doesn't seem like the best approach. Anyone have other ideas?
>>
>>Maybe design different classes to handle different issues. Instantiate/use the relevant class depending on the issue type.
>>Regards,
>>Viv++
>
>But the question still is how to make that determination without having some kind of code in table. I can't see any way around it.

PMFJI,

Just to elaborate a little on Viv's suggestion, you don't need any code in the table, just a class name and assembly name. The class could either implement an interface or inherit from a base class. There was a discussion about this in the Interfaces thread a couple of weeks ago.

Bruce