title: How to make composite key using foreign keys?
body: <p>I have a primary key <code>CustomerNo</code> from a table and another primary key <code>ProductNo.</code> from another table. I want to use them as composite key in addition to a third column called <code>Date</code> in a third table called Order. So the idea is that in the Order table, I have a composite key that is <code>CustomerNo-ProductNo-Date</code>combined. The <code>Date</code> (as an individual column) may be duplicated in the table. However, the composite key combination will remain unique. How do I make this possible? </p>