MS Access Create Table & Modify Table Commands

Example Parent Child with AUTOINCREMENT CREATE TABLE table1(id1 AUTOINCREMENT, name1 TEXT(50), CONSTRAINT table1_PK PRIMARY KEY(id1)); CREATE TABLE table2(id2 AUTOINCREMENT, id1 INT NOT NULL, name2 TEXT(100) NOT NULL,

www.pssuk.com