How can I add a table to an existing Access database. Require a field type of AutoNumber and a DELETE CASCADE relationship to another table. I already try to execute SQL.
Printable View
How can I add a table to an existing Access database. Require a field type of AutoNumber and a DELETE CASCADE relationship to another table. I already try to execute SQL.
Use data type COUNTER to create autonumber column. ( CREATE TABLE TAB_Account (f_ID COUNTER CONSTRAINT c_primary PRIMARY KEY, ... ) ). Check MS Access Help for available types and CREATE TABLE syntax.