Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 810C5476B33
	for <pgsql-sql@postgresql.org>; Fri,  7 Jun 2002 16:42:28 -0400 (EDT)
Received: from pony (office.weilpublishing.com [207.5.188.53])
	by postgresql.org (Postfix) with SMTP id 18D90476360
	for <pgsql-sql@postgresql.org>; Fri,  7 Jun 2002 16:05:17 -0400 (EDT)
Received: (qmail 19410 invoked from network); 7 Jun 2002 19:58:25 -0000
Received: from unknown (HELO weilpublishing.com) ([192.168.1.61])
	(envelope-sender <matthew.berardi@weilpublishing.com>)
	by 192.168.2.2 (qmail-ldap-1.03) with SMTP
	for <pgsql-sql@postgresql.org>; 7 Jun 2002 19:58:25 -0000
Message-ID: <3D0110C1.5020908@weilpublishing.com>
Date: Fri, 07 Jun 2002 16:00:01 -0400
From: Matt <matthew.berardi@weilpublishing.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:0.9.9) Gecko/20020412 Debian/0.9.9-6
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: multiple primary keys and reference
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200206/106
X-Sequence-Number: 8071

I have a table, OrderDetail, with two primary keys OrderID and ProductID

I want another table, Claims, to reference the primary keys of 
OrderDetail so that the pair has to match between table not just one 
attrib. I can't figure out how to do this from the docs I have. can 
anyone help? thankyou in advance

matthew berardi
weil publishing