Combination of fields must be unique

I have two fields in a table. Neither is required. I want each field to be
unique as well as the combination of both fields.

I have tried doing this with the index table:

Field1: unique
Field2: unique
Field1AndField2: unique

But I am still able to enter the same value in both Field1 and Field2

Thanks for any help,
Seth

.

Relevant Pages

  • Re: How to find Minimum of four fields
    ... SELECT Id, Field1, Field2, "PhoneCost" AS CostType, PhoneCost AS CostAmount ...
    (microsoft.public.access.gettingstarted)
  • Re: How to find Minimum of four fields
    ... Let's assume you currently have a table with Id, Field1, Field2, WebCost, ... PhoneCost, StoreCost, and ShowCost. ...
    (microsoft.public.access.gettingstarted)
  • Re: Combination of fields must be unique
    ... Seth wrote: ... > But I am still able to enter the same value in both Field1 and Field2 ... A unique index on two fields does not prevent you from enter the same value in ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Querying by multiple dates
    ... UNION ALL SELECT Field1, Field2, Date2 AS VisitDate ...
    (microsoft.public.access.queries)
  • Re: Copying a Field
    ... Since Field1 has no value on a new record, niether will Field2. ... > field is the primary key and a second field will for the some of the time ... > Debbie D. ...
    (microsoft.public.access.forms)
Loading