Eliminate duplicate times

[Michelle Logan]

In our portal, we have a Start Date and a Start Time field (popup value list of times).

These fields let an instructor indicate the day and time they started a session.

When an instructor completes the session they can start a new session and time on a new portal row.

A small problem we have is that an instructor may start their session today at 1:00 p.m., then for their next session (on a new portal row) they may accidentally select 1:00 p.m. again (instead of 1:15 p.m.).

Is there a way to stop them from entering the same start time for any of today's sessions.

Michelle

[comment]

Define a self-join of the portal table:

Sessions::InstructorID = Sessions 2::InstructorID

AND

Sessions::StartDate = Sessions 2::StartDate

AND

Sessions::StartTime = Sessions 2::StartTime

AND

Sessions::SessionID ≠ Sessions 2::SessionID

Validate:

not Sessions 2::SessionID

[Michelle Logan]

Thank you for the quick reply and the information.

I Have not done a self-join, but this looks like it may be a good time to jump in feet first!

Michelle