This is a generic database design question. But I didn't see a topic where I could post this. Since I am using SQL Server, I thought I would post it here.
I am designing a 'help desk' site and I have a master table called 'Requests'. I have another table called 'FieldsToInclude' which contain the following fields:
I have a form that will list these fields as checkboxes along with a textbox next to the 'other' checkbox so that the user can specify what 'other' field they want included.
I am having a hard time creating a design for this scenario. I have created another table called FieldstoIncludeLookup which has the following fields:
RequestId (FK to the master table's PK)
FieldsToIncludeId (FK to FieldsToInclude.FieldsToIncludeId)
However, I can't think of a way to include the text contained in the 'other' textbox if somebody selects the 'other' checkbox.
Please let me know if I should post this question elsewhere.