SQLite Forum

Help with foreign key
Login
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