I am reading through Andrew Pitonyak's AndrewBase document (http://www.pitonyak.org/database/) and tried his example creating DEALER and ITEMS tables (around page 24). The tables are very simple:
Code: Select all
DEALER table
Field Field Type Comment
ID Integer [INTEGER] Table's primary key
NAME Text [VARCHAR] Dealer name.
ITEM Table
Field Field Type Comment
ID Integer [INTEGER] Table's primary key
NAME Text [VARCHAR] Item name.
DEALER Integer [INTEGER] Dealer ID.
missing DEFAULT value on column DEALER in statement [ALTER TABLE "ITEM" ADD FOREIGN KEY ("DEALER") REFERENCES "DEALER" ("ID") ON UPDATE CASCADE ON DELETE SET DEFAULT]
Clicking OK deletes the relationship between the tables.
If I then go back to edit the table in the Table Design screen I find the default value is no longer there.