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...