Adding a new table

[TriTran]

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.

[Cih]

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.