On Tue 02 Sep 2008 04:06:20 PM EDT, Martin Gainty wrote: > you can use setup a foreign key constraint in your create table so that col= > umn is only populated when > there is a value which syncs to the referenced value > http://www.postgresql.org/docs/7.4/interactive/sql-createtable.html I don't think that will work. When somebody inserts (99, 98) into product_location, I want to make sure that product ID 99 has the same customer ID as location ID 98. Matt
