Jump to content

need helping how to check for conflict with record


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

Recommended Posts

Hello,

I am writting simple event schedule. I need to figure out how i check for conflict when someone try to create event for the same city, time, room. Example would be Austin, 3:00pm, room B. if someone try to create a record with the same info, i want a message to pop up and inform the person who is entering that datat that city, time, room are already taking.

Link to comment
Share on other sites

You could -

Create a concatenation of the fields in a calculated field.

Then, use this in a relationship to check with the IsValid function.

If it is valid then a record previously exists. You can then go to that related record and pull up that information in a dialog box.

Link to comment
Share on other sites

This topic is 6509 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
 Share

×
×
  • Create New...

Important Information

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