Hi,

I'm going round in circles so some help would be appreciated.

I have an Updateable view who's base table has a unique ID (from a lookup table), the base table has a default value that is a function that gets the next ID - that's all fine however when I add a record to the view it doesn't have the default value in it so I've set the same call in the default value of the view - how I'm finding that the ID is incrementing twice!

How should I be doing this?

Thanks in anticipation
Caroline