[RBG7-L] - RE: Using Insert to add a null row

[Walker, Buddy]

Alstair    Don't use the autonum col.  Something like      INSERT INTO Temp_Table (othercol) VALUES (NULL)   Buddy      -----Original Message----- From: Alastair Burr [mailto:[EMAIL PROTECTED] Sent: Thursday, September 30, 2004 2:11 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Using Insert to add a null row I have a form with a temp table that I want to start with 1 row displayed ready to accept data.   I can create the table and add an AutoNum as I want but how do I use Insert to prime the table with other null values for the row?   I want to do something like:   INSERT INTO Temp_Table (AutoNum_Col) +   VALUES ( [first autonumber] )   Thanks in advance for any help, Regards, Alastair.   ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ----------------------------------