Duplicate records

[mariaw]

Hi

I have a table (which is populated by people filling in a form) which contains two fields:

Section
WeekCom (e.g. week commencing)

I want to make sure that the form will not allow someone to make a double entry. For example, if Sally goes in and says enters "Benefits" as the section and "WeekCom" as 15/10/06, and then Ben tries to do the same - the form will not allow Ben to enter it.

How do you do this please? The table does not have a primary key at the moment....is there any way of doing it without setting one of the fields as a primary key?

Thanks

Maria

 

[Ron_dK]

Maria,
Why would you limit the entries in the table. Why can't Sally and Ben work on benefits both.
I would recommend to extend the table with a third field, e.g. section-specifics in which differentiated details relevant to a certain benefit can be entered.
Hope that makes sense.

 

[mariaw]

Hi Rak

Sorry, I don't understand (probably my fault not yours - I want to make sure that Ben cannot go in an make an entry for the "Benefits" section for the week commencing "15/10/06" if Sally has already made this entry?

Maria

 

[ejstefl]

You can set an index on both fields that will prevent duplicates.

 

[mariaw]

Hi Pat

That's great thanks - that has done the trick!

Maria