Hi

Just to explain myself a bit further all the tables take this form

CREATE TABLE [dbo].[MED_Progress] (

 [ID_rec] [int],

 [Entityref] [varchar] (15),

 [Matterno] [int],

 [Medical_ref] [varchar] (25),

 [Progress_notes] [varchar] (512),

 [Status] [int],

 [Time_stamp] [datetime],

 [sr_Confirm] [int],

 [InstructionID] [int],

 [Agency_Confirm] [bit]

)

CREATE TABLE...

As a colleague of Steve's I resent that statement.