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
Caroline