Duplicate values

I have a table that contains 4 fields for completion in a form.

I do not want users creating entries via the form where 2 of the fields
contain the same data as another record. I cannot set the table to disallow
duplicates on the fields individually as they are allowed and are correct,
however it is a combination of the two fields that I want to make unique -
how can this be achieved?
--
Kevin
.

Relevant Pages

  • Re: Auto Filter Limit Question
    ... >Autofilter will only show the first 1000 entries in the dropdown. ... I have to find duplicates and get the last date ... >> I was using the Auto Filter but ran into a wall! ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Trying to create "related record exists" checkbox
    ... Matt, I set up my field exactly as you described, performed a find on ... and it still came back with 0 entries. ... Kevin ... Prev by Date: ...
    (comp.databases.filemaker)
  • How do I type over the face of my full spreadsheet...like "COPY"?
    ... I have a full spread sheet of 10,000 description of entries that are ... There are duplicates in this spread sheet and I need to leave them ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: Check for duplicate numbers from ones entered and anoter set
    ... iFinish = iRow ... entries failed" ... 'tell user what the duplicates are ...
    (microsoft.public.excel.programming)
  • Re: 3 fields together unique/no duplicates?
    ... will only allow unique combinations of the three field entries. ... this is an easy way to do it, but not necessarily the best design. ... Ideally, you would use an autonumber PK field in tblPeople, which would make ... > allow duplicates but I need to use 3 fields. ...
    (microsoft.public.access.tablesdbdesign)