Alpha Video Training
Results 1 to 2 of 2

Thread: Unique field test

  1. #1
    Al Terpak

    Default Unique field test

    I'm looking for a way for A4 V6 to test a field as it is being
    entered to see if it is unique. The field is an alpha numeric 10
    character entry in a record. I then want the database to look
    into the existing data file to see if any other record has this
    same information in that same field. This filed is used to assign
    an accession number which must always be unique for each record.
    It is a required field for every record. If it finds that another
    record has the same data in that field, it would then give me an
    error message stating such.

    Can this be done in A4 V6 and if so then what method do I use to
    accomplish this task. Thanks for your help.

    Al Terpak

  2. #2
    Real Name
    Gary Smith
    Join Date
    Apr 2000

    Default RE: Unique field test

    In the TEST database, the field rules for FIELD2 use a validation trigger called FIELD2VT. Look at that script. Look at the TESTUNQ index. It only allows unqiue values.

Similar Threads

  1. Test if field exists at startup
    By Scott Emerick in forum Alpha Five Version 5
    Replies: 2
    Last Post: 09-04-2003, 09:27 AM
  2. Unique Count Test
    By Jeff Wells in forum Alpha Five Version 5
    Replies: 5
    Last Post: 03-27-2003, 02:23 PM
  3. test for blank number field
    By Tom Patten in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-07-2003, 10:14 PM
  4. Unique test
    By Jeff, Richards in forum Alpha Five Version 5
    Replies: 12
    Last Post: 12-26-2002, 08:08 AM
  5. test for blank field
    By Carl Elmore in forum Alpha Five Version 4
    Replies: 6
    Last Post: 07-03-2002, 06:09 PM


Posting Permissions

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