help on duplicate entry

[bill crumpton]

How can I restrict a record to not be duplicated per date but able to be duplicated on another date. For example, today I do not want the user to be able to duplicate a certain field in a record but tomorrow I want to allow the user to be able to duplicate the field. Any help on this please??

 

[gino]

i am a bit confused on what you really want. can you be more specific? but anyways...if you want to have no duplicates...check your indexes.....in your table.

if you want a user not to duplicate dates you should have multiple indexes by userid and date.

[This message has been edited by gino (edited 04-22-2000).]

 

[bill crumpton]

thanks for your help Gino.....I designed a database thats information is grouped and entered by date. I have a combo box on a form that hold a list of items for the user to choose from. I need for the user to be able to choose only ONE of those items PER DAY. If the user tries to choose the same item on the same day I need a pop up box to give instructions. However, I want the user to be able to choose that item on the next day. This is why No Duplicates doesn't work. Any Suggestions?

 

[bill crumpton]

I am sure I am being confusing, I want duplicates but not within the same date, but on different dates duplicate entries are fine. I want to restrict duplicate entries only to the same date. I have been trying to figure this out for 2 months now.

 

[Carol]

The answer that Pat Hartman gave is correct. Go back into your table and move your RecordID field and your DateField to one below the other. Highlight the first line and while holding the mouse button, move down to the next line and create 1 primary join key field. This will solve your problem.

 

[bill crumpton]

I tried that Pat & Carol, however I do want to duplicate the field but just not on the same date. I may be the one confusing the question Pat but I do not want to be allowed to duplicate the same field on the same day but I do need to be able to select the field on the next day.