>Can you post the table structure and SQL code for the view? Are you sure that base table is being updated on add and edit? Is "send SQL updates" checked in the update criteria tab of the view designer?

Elmer,

In reply:

Can you post the table structure and SQL code for the view? Yep

SQL SCRIPT:

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]
GO

VFP SQL

SELECT *;
 FROM dbo.agr_useraccess Agr_useraccess;
 ORDER BY Agr_useraccess.usr_reference, Agr_useraccess.usr_lastname,;
  Agr_useraccess.usr_firstname

Are you sure that base table is being updated on add and edit? Yep

Is "send SQL updates" checked in the update criteria tab of the view designer? Yep

Thanks for the time... I don't like to go to sleep until I nut out things like this... :-)

Ric