take table query with primary key needed

  • Thread starter Thread starter timc
  • Start date Start date
T

timc

i am developing a make table query within a macro. once
the table is made, i will be appending additional
information to the query. there is the potential for
duplicate items to be included in the table. if i add a
primary key, i can prevent the duplication of records. is
there a way to incorporate a primary key when the table is
made by a "make table" query?
 
I've not tried this but according to the help screens. . .


CREATE TABLE Friends
([FriendID] integer,
[LastName] text,
[FirstName] text,
[Birthdate] date,
[Phone] text,
[Notes] memo,
CONSTRAINT [Index1] PRIMARY KEY ([FriendID]));
 
i understand. thank you
-----Original Message-----
I've not tried this but according to the help screens. . .


CREATE TABLE Friends
([FriendID] integer,
[LastName] text,
[FirstName] text,
[Birthdate] date,
[Phone] text,
[Notes] memo,
CONSTRAINT [Index1] PRIMARY KEY ([FriendID]));


i am developing a make table query within a macro. once
the table is made, i will be appending additional
information to the query. there is the potential for
duplicate items to be included in the table. if i add a
primary key, i can prevent the duplication of records. is
there a way to incorporate a primary key when the table is
made by a "make table" query?
Click to expand...


.
Click to expand...
 
Back
Top