Items to be raffled can be donated or purchased. The Donations and Purchases tables each have the item ID as their PK.
The Raffles table should have the PK as either the Donations or the Purchases item ID. How do I write the DDL creating the Raffles table so that the PK is either a donated or purchased item_id number? I've only had a foreign key reference one specific table, not either of two tables and I've not found a solution in the references available to me. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users