specifying a foreign key by altering a table

[zufie]

Hi,
I want to specifying a foreign key by altering a table.

First, I create an ORDERS table without specifying a foreign key. Here
is my code:

CREATE TABLE ORDERS
(Order_ID integer,
Order_Date date,
Customer_SID integer,
Amount double,
Primary Key (Order_ID));

Next, I specify a foreign key by altering a table. Here is my code:

ALTER TABLE ORDERS
ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID);

What can I do to make this code work with MS Access?

Thanks for your help!!!!!!!!

Zufie

['69 Camaro]

Hi, Zufie.

I want to specifying a foreign key by altering a table.

Try:

ALTER TABLE ORDERS
ADD CONSTRAINT ORDERS_CUSTOMER_FK
FOREIGN KEY (Customer_SID)
REFERENCES CUSTOMER (SID);

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"zufie" <jo***********@illinois.govwrote in message
news:11*********************@r56g2000hsd.googlegro ups.com...

Hi,
I want to specifying a foreign key by altering a table.

First, I create an ORDERS table without specifying a foreign key. Here
is my code:

CREATE TABLE ORDERS
(Order_ID integer,
Order_Date date,
Customer_SID integer,
Amount double,
Primary Key (Order_ID));

Next, I specify a foreign key by altering a table. Here is my code:

ALTER TABLE ORDERS
ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID);

What can I do to make this code work with MS Access?

Thanks for your help!!!!!!!!

Zufie