Sir:
I have two tables customer and order defined as follows:
create table customer (
custno integer not null,
name varchar(30),
address varchar(30),
primary key (custno));
create table order (
orderno integer not null,
custno integer,
orddate date,
amount numeric(7,2),
primary key (orderno));
create sequence 'next_cust' start 1;
create sequence 'next_ord' start 1;
My problem is how would i implement referential integrity so that
whenever i insert a new order, it should check first if the custno exist
in the customber table. Can somebody please show me an example how would i
do it in this case?
Thank you...
Manny C. Cabido
====================================
e-mail:manny@tinago.msuiit.edu.ph
manny@sun.msuiit.edu.ph
=====================================