Re: referential integrity (fwd)

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(at)tinago(dot)msuiit(dot)edu(dot)ph
manny(at)sun(dot)msuiit(dot)edu(dot)ph
=====================================