if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[agr_useraccess]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[agr_useraccess] GO CREATE TABLE [dbo].[agr_useraccess] ( [usr_reference] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [usr_firstname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [usr_lastname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [usr_password] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [usr_accesslevel] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [usr_createby] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [usr_createon] [datetime] NOT NULL , [usr_modifyby] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [usr_modifyon] [datetime] NOT NULL , [usr_active] [int] NOT NULL ) ON [PRIMARY] GOVFP SQL
SELECT *; FROM dbo.agr_useraccess Agr_useraccess; ORDER BY Agr_useraccess.usr_reference, Agr_useraccess.usr_lastname,; Agr_useraccess.usr_firstnameAre you sure that base table is being updated on add and edit? Yep