I don't usually use views but the current application I am writing seems to work better using them. I have a stored procedured (nextNum) in the DBC table that the views are based on that increments the key value (integer). Problem is when The use clicks the Add button, append blank creates a new record but the key field is zero. How does the SP get fired? I can't find a requery method. Any help is appreciated.
Thanks, Chuck
Extreme Programming = Plan -> Design -> Code -> Test