[AccessD] Initial value of an ANPK

Susan Harkins ssharkins at gmail.com
Thu Dec 6 13:36:23 CST 2007


You just create an append query Arthur and set the ANPK's field to one less 
than you want the first value to be -- just open a fixed query in Design 
view, choose Append from the Query menu, specify the table... run it.

Open the table, delete the record you just appended.

Susan H.


>I figured it was something like that, but how do I append a record and 
>force
> the value of the ANPK? Not sure how.




More information about the AccessD mailing list