unique 2 or 3 fields

[nickelsto]

I am looking for the method of creating a record that requires the data in two (or more) fields be unique. Thanks in advance.

[comment]

See if this helps.

[nickelsto]

I appreciate your response. After reading through the threads it looks like this has been discussed quite at length.

If I understand correctly, to make 3 fields validate to be unique I need to create a join table with a concatenated field of the three kf fields. The concatenated field needs to be unique and if a non-unique entry is made in the other table then an error warning would appear from the join table. Is this correct?

Thanks again

[comment]

I am afraid not. If you want to go with a concatenated field, you define it in the same table as your 3 fields. No join table or relationships required.

[nickelsto]

oh, of course, that's it. Very simple. That should do it. Thank you

Edit

No, I already tried this a while back. You can't make a calculation field unique. So what am I missing?

Edited November 9, 2006 by Guest

[comment]

You are missing the part where I said:

... define a text field, set it to auto-enter a calculated value =

CustID & "|" & GetAsNumber ( AppointmentDate ) & "|" & AppointmentTime

Uncheck the "Do not replace existing value.." option. Set the field's validation to 'Unique value'.

[nickelsto]

Right, duh, ok. Thanks.