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" <[email protected] on behalf of [email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
