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...