Preventing Data Entry Errors

[vepz]

I have a db that track numerous different part numbers along with the length of each part. It is possible for the same part number and length to be recorded numerous times per job. Both the part number and the length are entered for each record. I accidentally entered the part numer with a different length. This is a problem. Is there a way to ensure that once a part numer and length is entered, if the same part number is entered along with a different length, the user is flagged to check the data?

Thanks,

Greg

 

[lespaul]

add an index (unique) to part number (in the table design)...that will restrict the table so that a part number can ONLY be entered once.



Leslie

Have you met Hardy Heron?

 

[vepz]

Unfortunatley, I need to be able to input the part number more that one time. What I need is a way that notifies me if the same part number is entered with a different length. Then I could check into the problem and get it corrected.

 

[lespaul]

Maybe create a table that lists valid combinations of Parts and lengths?

Leslie

Have you met Hardy Heron?