Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2016
    Posts
    12
    Provided Answers: 1

    Unanswered: Restricting a Drop Down Selection based on Current Date

    I have an application whereby the user has a default date field (Today) and has to select a shift from 1 of 6. So the user will enter 6 lines of data, each shift selected once per day.
    What I would like to do is prevent a duplicate shift being entered each day. I cannot make column (no dups because obviously there will be an early shift every day, a late shift every day etc.)

    Looking for some inspiration to solve this.
    Many thanks for reading.

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    1,101
    Provided Answers: 17
    Why not create a unique index on the user, date and shift no fields?
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •