>I want to use the identity column but I want to know the value of the identity on insert not on save. I am using a VFP 6.0 interface. I have tried using a trigger on insert but how do I get the value of the seed to display?

You mean before the insert ocurrs? What would you use that for?

After the insert the value is available by looking at @@IDENTITY. You can return this value in an output parameter of a stored procedure for use at the client.