How make an ID out of 3 fields combined.

[eds27]

Hello people.
Im working with 3 databases in lotus approach.
One is Employees, the other is Courses and the otherone relates the other two.
There are several fields in this third database. Three of them are:
- Employee serial
- Course Code
- Date
I want these 3 fields combined to be the ID of this database. An employee should only be allowed to take one course per date, but he could have several other courses taken in different dates.
If I select unique for the 3 of them then I can only insert one record for every employee serial, or course code, or date. Which is ridiculous, obviously.
How do I make these 3 fields together be the ID??
Please, I need help ASAP.
Thanks in advance guys.

 

[suesloan]

Create another field with a modification formula using COMBINE() to combine the content of the three fields. Validate this field as "unique" and it will prevent you from entering two records with the same value in all three fields. Something like this formula:

Combine("Employee serial","Course Code",DateToText("Date",'mm-dd-yyyy")).


Sue Sloan
XpertSS.com