Here is an example of what I want to do (syntax might not be entirely
correct as this is just an example):

CREATE TABLE ParentA
(
  name CHAR (6) NOT NULL;
  address CHAR(64);
) IN CUSTOMER_TS INDEX IN CUSTOMER_TS;

CREATE TABLE Child1
(
  name CHAR(6) NOT NULL;
  otherinfo CHAR(64);
) IN CUSTOMER_TS INDEX IN CUSTOMER_TS:

ALTER TABLE ParentA PRIMARY KEY (name);
ALTER TABLE Child1 FOREIGN KEY CUSTNAME (name) REFERENCES ParentA ON
DELETE CASCASE;
CREATE TRIGGER name_insert AFTER INSERT ON ParentA REFERENCING NEW AS
new_temp FOR EACH ROW INSERT INTO Child1(name) VALUES (new_temp.name);

So basically, when a record is inserted into the ParentA table, a
Child1 records is also created.  Also, If the ParentA record is
deleted, the Child1 record is also deleted.

What I also want to do is to restrict someone from deleting the record
in Child1 if the record in Parent1 exists (which it should always
exists).  I just dont want them to be able to delete the child...if the
record is to be remove, then its both or nothing.  I am also worried
about getting caught up behind the delete cascade too if I am able to
restrict the child from being deleted.

Any suggestions?