RE: Create table ID field

[Robert Orlini]

One more thing please Jochem. What if I want to AutoNumber the primary id field? I can do that from the Access table, but is there a way to do it when I create the table?


Thx!


RO

-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 11:51 AM
To: CF-Talk
Subject: Re: Create table ID field

Robert Orlini wrote:

> How do I do this? I've tried different ways. Is it in the Insert section?

INSERT INTO #trialname# (ID, Orderdate, Institution)
VALUES (#ID#, '#DateFormat(Now())#', '#FORM.Institution#')

Jochem

--
I don't get it
immigrants don't work
and steal our jobs
     - Loesje
  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---