Seems like you'd want to create a rowid primary key (internal_id integer primary key) that's the foreign key for the other table.
On 2/15/18, 1:19 PM, "sqlite-users on behalf of Michael Tiernan" <sqlite-users-boun...@mailinglists.sqlite.org on behalf of michael.tier...@gmail.com> wrote: (The objective is to have a single field in another table that identifies the CPU used in a system. It will be a many-to-one reference to this CPUModel.) Any advice? Pointers to documentation offering advice will help too. Thanks for everyone's time. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users