> Note that the columns in a primary key must be constrained NOT NULL for a "without rowid" table. I assumed that since the exsite_id column must match a value in the WeatherSites(wxsite_id) column that 'not null' was implicit. > The keyword "constraint" Oops! I forgot that. Thanks. > The keywords WITHOUT ROWID to designate that a table does not have a rowid is a qualifier of the table, not of the contents in the table. As such it follows the ()'s delimiting the contents of the table. I must have missed that when reading the syntax page. Data are entered by users, not automatically. Thanks, Rich