I was hoping that somebody else gives you a more relevant answer. Anyway, I don't user autoinc fields; instead, I assign a value through a UDF of the table. This works both in the table, and in views based on the table. The UDF will check for the next available number, in a table of sequence numbers.
>I originally posted this question on the "Database, tables, Views..." Category and got no reply so I thought I'd try my luck here. Is my situation/question so unusual? Here goes...
>
>
>I have a view of a table that includes an autoinc field from the underlying table. When I insert a new record into the view, the autoinc field does not autoinc like it does when I insert directly to the table itself.
>
>Is there some way that I can have the view get the autoinc value that the table would use without actually adding the record to the table? After all, that would defeat the purpose of my buffered view wouldn't it?
>
>VFP8SP1 in Win2000Pro
>
>Thanks in advance
>
>Mike
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
