Hi!

I just re-posted my FAQ article from the www.tek-tips.com here. It will apear soon. Take a look to it to see one of the approaches and check if you;re doing correct way (seems you used the same approach).

HTH.

>Hi everybody - I ask this after a lot of reading of the help files and searching through the calendar looking at posts and also a lot of "trying it out"
>
>I have a customers table. When I append blank a stored procedure adds the primary key. GREAT.
>
>I created a view based on this table - I check update criteria - update all including the primary key (not sure if I'm right or not here) and send sql updates.
>
>I have a form with textboxes bound to the view.
>
>What is the best way to add/delete records, making sure the primary key gets maintained?
>
>If I've missed posts on this I'am sorry but I have spent quite a while searching...