Resource Management

[kcid]

I hope I am posting this in the correct part of the forum.

I am trying to do some resource management.

I have multiple pieces of equipment which are loaned out for various periods of time. People often reserve months in advance.

There may be 10 advance reservations for one particular piece of equipment, and I need to identify if a new requested period is in conflict with an existing reservation for that piece of equipment.

I am not asking someone to do this for me, because if I don't do it, I won't learn it. But I would appreciate some guidance or aiming me in the right direction.

[comment]

See if this helps:

http://fmforums.com/forum/showpost.php?post/303839/

[kcid]

Thank you. I was able to make it work for me once I understood the self relationship method. Once again you got me out of a hole. Sometimes I find myself going down the rabbit hole and not knowing the way out.

Rather than a validation, I used conditional formating that turns the text [color:red]BOLD and [color:red]RED when [NOT IsEmpty( EQ2:_ID)]. Then they can go back and fix the conflict from the other end if they want.

Thanks once again.