Alpha Video Training
Results 1 to 4 of 4

Thread: Previous values lookup unique values only

  1. #1
    Member
    Real Name
    gfong
    Join Date
    Jan 2001
    Location
    Dartmouth, Nova Scotia, Canada
    Posts
    369

    Default Previous values lookup unique values only

    Anyone figure out how to create a previous values lookup with unique values only? I have a field called CATEGORIES which the user can add new classifications to. The problem is that the previous field lookups don't seem to have a way to make them unique.

  2. #2
    "Certified" Alphaholic
    Real Name
    Thomas Patten
    Join Date
    Apr 2000
    Location
    Duluth, MN
    Posts
    1,494

    Default RE: Previous values lookup unique values only

    Greg,

    I thought by definition, if you select "previous values" in field rules, it automatically creates an index and makes it "Unique Values" for the lookup.

    And if you do not want duplicates use the Key_Unique function in a validation expression, again in field rules.

    But I think I'm missing something in your question.

    Tom

  3. #3
    Mick Magnuson
    Guest

    Default RE: Previous values lookup unique values only

    Hi Greg
    Sometimes on a form I will put a button next to the field that pops up an array of uniques values for the field. The users chooses the item and it fills the field. The button is conditional and only shows during enter or change mode.

    Same result, just gives the form a different look.

  4. #4
    Member
    Real Name
    gfong
    Join Date
    Jan 2001
    Location
    Dartmouth, Nova Scotia, Canada
    Posts
    369

    Default RE: Previous values lookup unique values only

    Thanks Mick! Didn't think to do that.

Similar Threads

  1. Previous Values
    By Ed Barley in forum Alpha Five Version 6
    Replies: 4
    Last Post: 04-13-2005, 04:05 PM
  2. Previous values
    By johngt in forum Alpha Five Version 6
    Replies: 10
    Last Post: 01-31-2005, 11:56 PM
  3. Lookup previous values trumps unique validation
    By Dale Stansbery in forum Alpha Five Version 5
    Replies: 4
    Last Post: 03-17-2004, 10:10 AM
  4. Lookup previous values
    By Bruce MacPherson in forum Alpha Five Version 4
    Replies: 5
    Last Post: 07-26-2000, 02:51 PM
  5. Display unique values in lookup field rules?
    By Bill Warner in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-19-2000, 08:10 AM

Bookmarks

Posting Permissions

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