Newbie - Making sure users follow the rules

[techsponge]

How can you ensure a form will not allow duplicate records to be created?

My form has 6 fields that are from table 'tblemployee'. The control names and database field names are the same.

name
DOB
position
hire date/time
pay rate
badge #

When a user enters 'BOB, SMITH' in the name field and '2/8/2006 11:00:00 AM' in the hire date field, if this combination exists in the database do not allow the user to proceed?

 

[PHV]

1) create a composite unique index on (name,hire date/time)
2) in the data entry form play with the DLookUp function

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[techsponge]

Thanks
I was thinking about the dual PK. The default for hiredate is NOW(), so if I enter the new hire record for 'Bob Smith' hired today '2/8/2006 1:49:00 PM' and then forget that I enetred the record and re-enter next week as 'Bob Smith' and change the hiredate default value to '2/8/2006 8:00:00 AM' the record will still be accepted since the name/hiredate is unique?

 

[PHV]

Use Date() instead of Now()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Lilliabeth]

I'd like to point out that "create a composite unique index on (name,hire date/time)"

is not the same as "dual primary key".

 

[techsponge]

Thanks for the information, unfortunatly my boss wants a hire date and time......he just can't make it easy.