Re: Specifying Unique keys

[CRPence <CRPbottle@xxxxxxxxx>]

lwl wrote:
> <<SNIP>>
>
> I want to establish the fields at lines 11 and 16
> as unique keys - for any record inserted in the file
> these 2 fields must be unique to the file.
>
> Specifically what coding is required to make this happen?

  What is meant by "these two fields must be unique to the file"?  Does 
that meant to suggest that the combined data from both field for all 
rows must have unique data; i.e. unique data across the effective 
concatenation of the values in the two fields?  Or perhaps the meaning 
is that each column must never have a duplicate value, irrespective of 
what value is in the other column?  For the latter case, that would 
require creation of two separate unique keys, each encapsulated in a 
separate files [or constraints].

Regards, Chuck