unique records via 2 fields

[captjase]

Newbie question..

I'm lookin at the time billing template that comes with FMPro5.5 and I would like to validate each record so that the combination of Employee ID and Week Beginning Date is unique i.e. Each employee can only have 1 timesheet for each week - no duplicates.

I tried creating a new field (calculation) that was the combo of both of these - but I don't seem to be able to make it unique.

Any suggestions, a better way perhaps?

Cheers

Jase

[simon1663]

Well,I did face the same problem in past and realized there is no built-in feature from Filemaker which will resolve the problem. So, I implemented it using a script. At the end of filling a timesheet - user clicks a OK/Done button which does some validations. You will need to make sure that user is not able to jump to another layout though.

I am not 100% sure if there is any automated feature from filemaker which will help you to do this. I have tried it with self-join relationship, lookup etc but never got it to work. Hence took the long way of script.

Regards,

simon1663

[Vaughan]

Take a look at FileMaker TechInfo Article Number 104191: "Unique Validation of Calculation Field."

The article describes validating a calculation field that concatenates "first+last" names, but it's only a short stretch to modify the technique to what you want to do.

The TechInfo database is at

http://www.filemaker.com/support/techinfo.html

[captjase]

Excellent - thanks for your help guys!

Really appreciated!!

Cheers

Jase