Lookup validation to prevent duplication

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Platform Access 2003
OS XP

Senario

Each month I have to append to a table a current list of manufacturers and
in one of the columns is a date with the format mmm yyyy. I create this
data each month by clicking on a button.

Question

Is there a way that I can validate if a new data set has been created for
that month so a duplicate set of data is not created?

Thanks
Jason
 
This would be very easy if you can force the day-of-the-month to the first
at the point when you perform the input.

1. Open the table in Design view.

2. Open the Indexes (View menu).

3. Enter an index name, such as "MonthManufacturer"

4. Beside that, enter the name of your date field.

5. In the lower pane of the Indexes dialog, set Unique to Yes.

6. On the next line, leave the index name blank, and enter thename of the
manufacturer field.

This creates a unique index on the combination of the 2 fields. Access won't
allow duplicates.
 
Back
Top