John,

What about professionals that are changing their focus and don't have a lot or any experience.

Thanks

Brian

That did give me the same information with a lot less typing. Thank you.

My thanks to the two responders. Both suggestions look very helpful.

Brian

I was thinking of a child table for each of the three columns. Otherwise I'm not sure I understand your question.

Thank you for your insight. My primary key is the ticket number. I will definitely look at changing some of the columns to or to not require nulls.

The columns that I think should go into their own table are:

Priority - a number from 1 - 4

Assignee - User or group ticket is assigned to

Category - 1st level...

here is the information you were asking for:

CREATE TABLE [dbo].[Tickets](

[Ticket Number] [int] NOT NULL,

[Priority] [smallint] NULL,

[Assignee] [varchar](25) NULL,

[Category] [varchar](25) NULL,

[Vendor Ticket] [varchar](60) NULL,

[Open Date] [date] NULL,

[Opener] [varchar](30) NULL,

[Closer] [varchar](30) NULL

)...

did you ever resolve this issue? I'm experiencing the same issue.

Thanks

Brian