Thanks Mark.
>Sorry, I explained that badly. I use remote views so I can not update the table directly. What I was trying to say is I will use a view whose PK is updatable if I have to immediately know what the key is for use as FK in a child table. Otherwise, I tend to use views whose PK is not updatable. In all cases, the default value of my PK field is a function call to my PK generator. I always do INSERTs on a view that is updatable, I just vary on whether the PK is updatable depending on my needs.
>