for those who can help,
on my database i have two tables, organization and transaction, listed here;
-------------------------------------
create table organization(
organ_person_id serial primary key,
asset_id int,
fname text,
lname text,
phone varchar(15),
email varchar(20),
constraint organization_asset_id_fk foreign key(asset_id) references assets(asset_id));
create table transaction(
transaction_id serial primary key,
trans_date timestamp default current_timestamp,
return_date timestamp,
organ_person_id int,
constraint transaction_organ_person_id_fk foreign key(organ_person_id) references organization(organ_person_id) on delete cascade );
---------------------------------
what i want is for a delete on transaction to make a delete on organization where the organ_person_id s match up,with a query like;
delete from transaction where organ_person_id = 15; but this is not happening. all it does is delete from transaction, and doesn't touch organization. am i doing something wrong?
please help,
mike z
--
Mike Zouroudis
Intern
__________________________________________________
I.D.E.A.L. Technology Corporation - Orlando Office
http://www.idealcorp.com - 407.999.9870 x14