Jump to content

This topic is 3298 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 3298 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.