Validation

[msoussi]

I have a database with the folowing fields

Start time, End time, Date, and Room.

 

I am triying to creat a field with a validation that will let me know if another record has a room with the same date same strat otime and end time.

 

How do a I do this with validation and choose the calculation option.

Thanks

[comment]

You cannot validate a Calculation field. However, you can define a Text field and set it to auto-enter a calculated value (replacing existing value) =

StartTime & "|" & EndTime & "|" & Date & "|" & Room

and validate this field as Unique.

[msoussi]

thanks for the answer, It worked