Hi,

I am not ready to yet put this into the db so I would like clarification from anyone here, on whether I have it correct.

two tables

Code:
CREATE TABLE IF NOT EXISTS business_type 
( business_type varchar(25) NOT NULL
, business_sub_type varchar(32) NOT NULL
, business_category varchar(32) NOT NULL
, PRIMARY KEY (business_type,business_sub_type,business_category)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS business_details 
( business_id int NOT NULL auto_increment
, business_type varchar (25) NOT NULL
, business_sub_type varchar(32) NOT NULL
, business_category varchar(32) NOT NULL
, tic varchar (64) NOT NULL
, PRIMARY KEY (business_id)
, CONSTRAINT businessdetails_businesstype_fk 
    FOREIGN KEY (business_type,business_sub_type,business_category) 
      REFERENCES business_type (business_type,business_sub_type,business_category)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
bazz