OK I have a table Link, in this tab

[rbasram]

OK I have a table Link, in this table I have the fields REC#,TNum, Sequence, Title,DocumentID(Foreign Key),Product(Foreign Key), Is there a way I can set the candidate keys in access, in the table above I want that TNum, DocumentID and Product cannot be same for two records.

Does anyone know how to set this not through the code but via access.

 

[Fred]

Go to the design view of the table and create an index (click on the lightening bolt) which is the segmentation of the three fields, and then make the index unique.

The index has a singular name such as idxThreeFields and is made up of the three fields you mentioned. Visually when you are building it, it show look like this:
Index Field
----------------- ----------
idxThreeFields TNum
DocumentId
Product

 

[mailzero28]

Go to the table design - indexed section and select Yes No Duplicates.

bye

Martin.