Validating Records?

[ultrex]

Hi Guys,

I havent been onto this forum in a very long time. I need some help..

How can I stop two clerks adding the same job type twice? The data they are entering is employees who worked on a specific date and the hours they have worked and the division they worked at.

The fields used ; Date Worked, Hours Worked, Division, Employee Names.

Would I have do to a merge field for all these and do a calculation step?

Thanks.

[Ocean West]

one possible method is to create a set of "Global" fields where the users enter the data in the global fields. Then you provide a "submit" button where it then will evaluate if the data submitted already exists in the database thus rejecting any duplicate entries. Non duplicate unique entries would then create a new record and the real fields would be populated with the data in the global fields.