composite key

[ARCITS]

How do I define a composite key in FoxPro on fields InvoiceNo and ProdNo?
None of the usual SQL syntaxes seem to do the job

Any help urgently required


Regards

CREATE TABLE INVOICE_PRODUCT
(
InvoiceNo CHAR(6) PRIMARY KEY NOT NULL REFERENCES Invoice TAG InvoiceNo, ProdNo CHAR(5) NOT NULL REFERENCES Product_ID TAG ProdNo,
Qty INT(7),
Price FLOAT(4,2)
)

 

[marsh]

After creating the table,
INDEX ON InvoiceNo + ProdNo TAG InvProdKey