thirtyseventhirty_endtime datetime )</pre><BR><BR>I guess I have to create the attribute first before I set a foreign key on it? I don't remember the MSDN docs stating that..

SQLite will assume an explicitly named integer primary key is just an alias for the rowid if the type is spelled out as "INTEGER" rather than "INT." I can simply change my create table statement as ...