Requiring unique entries
UtterAccess Discussion Forums
Access Tables + Relationships
Oct 7 2005, 05:42 PM
OK. I am drawing a blank. How do I fix it so that a field can be null but, if not null, cannot contain a duplicate entry as another record?
Oct 7 2005, 05:57 PM
Open the table up in design, and on the field you want 'unique', select "Index" and make it NO duplicates.
Oct 7 2005, 06:04 PM
That was the answer I was looking for. Thanks. It had been so long since I did it that I did not remember how to do it.
Oct 7 2005, 06:20 PM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please