Avoid duplicate entries

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

I would like to limit users to one entry per day in a
table. Here are some of the fields in the table
ID - autonumber (PK)
UserID - text
Date - date
Unit - number
totalTrans - number

I would like to have it where the user (userID) can only
have once entry per date.

Thanks
 
You can set a key field in the table of USERID&DATE and not allow
duplicates.

To do so, go into design view for the table. Click the IserID and the Date
fields (you can hold CTRL while clicking). Then click your "key" icon at
the top of the screen.

If you point your cursor to the table's title bar and right click, you will
get a menu that includes an "indexes" icon. Clicking that will allow you to
modify some of the key properties.

rick B


I would like to limit users to one entry per day in a
table. Here are some of the fields in the table
ID - autonumber (PK)
UserID - text
Date - date
Unit - number
totalTrans - number

I would like to have it where the user (userID) can only
have once entry per date.

Thanks
 
Allie,
Let me add one thing to what Rick has suggested. Change the name of your
date field to something other than "Date". Date is a Keyword in Access and
it can cause confusion down the road.
 
Back
Top