Berto

Am i right in thinking that a relation database is only in the mind...

I mean i know you can link table using sql commands but is there an sql command to create a relationship between 2 tables, like ACESS does so that i can cascade delete on things?

-----------------------------------

edit worked it out myself dont worry

if anyone cares here is a lot of sql

CREATE TABLE site
(
ID INT NOT NULL,
Name VARCHAR(30) NOT NULL,
CONSTRAINT spk1 PRIMARY KEY (ID)
);

CREATE TABLE area
(
ID INT NOT NULL,
siteID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT apk1 PRIMARY KEY (ID),
FOREIGN KEY (siteID) REFERENCES site(ID) ON DELETE CASCADE
);





CREATE TABLE cell
(
ID INT NOT NULL,
areaID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT cpk1 PRIMARY KEY (ID),
FOREIGN KEY (areaID) REFERENCES area(ID) ON DELETE CASCADE
);

CREATE TABLE rack
(
ID INT NOT NULL,
cellID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT rpk1 PRIMARY KEY (ID),
FOREIGN KEY (cellID) REFERENCES cell(ID) ON DELETE CASCADE
);

CREATE TABLE shelf
(
ID INT NOT NULL,
rackID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT spk1 PRIMARY KEY(ID),
FOREIGN KEY (rackID) REFERENCES rack(ID) ON DELETE CASCADE
);

CREATE TABLE bin
(
ID INT NOT NULL,
shelfID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT bpk1 PRIMARY KEY(ID),
FOREIGN KEY (shelfID) REFERENCES shelf(ID) ON DELETE CASCADE
);


----------------------

it was setting up the foreign key references that i was trying to do.

__________________
"Put your hand on a hot stove for a minute, and it seems like an hour. Sit with a pretty girl for an hour, and it seems like a minute. THAT'S relativity."

- Albert Einstein