at the moment if a value is say inserted into the 'warranty_info' table
you are just checking that the 'product_id' or 'cust_id' already exists
in 'product_info' and 'customer_info'. you still have to populate them
first, otherwise the referential integrity will return an error when you
insert
Does this seem to be correct? With this if value was inserted into a
table will the tables with the FK's automatically be updated? Here is
the DB design as I have it now. Let me know if all is correct please.
CREATE TABLE customer_info (
cust_id int (6) UNSIGNED NOT NULL AUTO_INCREMENT PRIM
