Hi!
If you use default value for field in table to generate key, you can use the same approach for views too. In View Designer you can do this in the field properties dialog box. There are certain field properties for DBSTPROP that allow to set default value expression for field in the run-time mode.
>I have a grid which use a parameter view as record source. The property AllowAddNew which is set to .T.
>
>In table, I always put a function call at DEFAULT VALUE to get the surrogate key.
>
>But how can I get the Surrogate key for the view as I pratice in table?
>
>TIA.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.