I have one table, A and will create table B Both are autoincrement Table A is called mysales and has a field called supplier Table B will be called suppliers and will have a field called name Table B's primary ket will be id and the foreign key will be supplier in table A How can I write the CREATE TABLE statement correctly for table b Thank you, Angie